-
I've created a Csv file, and when I open it using TXT format, each line has quotation mark, how can I remove it? for ($i = 3; $i <= 5; $i++) {
$validOrderNumber = $templateSheet->getCellByColumnAndRow(10, $i);
if($validOrderNumber == $orderNumber){
if($orderNumber == '55270018/001'){
for ($j = 0; $j < 28; $j++) {
if($dataArray[16+$j]['A'] != '' and $dataArray[16+$j]['B'] != ''){
$finalArr1[$j][0] = $docSheet->getCell('K6')->getValue();
$finalArr1[$j][1] = sprintf('%02s',$j+1);
$finalArr1[$j][2] = $templateSheet->getCellByColumnAndRow(3, $i);
$finalArr1[$j][3] = $templateSheet->getCellByColumnAndRow(4, $i);
$finalArr1[$j][4] = $templateSheet->getCellByColumnAndRow(5, $i);
$finalArr1[$j][5] = date('Ymd');
$finalArr1[$j][6] = $templateSheet->getCellByColumnAndRow(7, $i);
$finalArr1[$j][7] = $templateSheet->getCellByColumnAndRow(8, $i);
$finalArr1[$j][8] = $templateSheet->getCellByColumnAndRow(9, $i);
$finalArr1[$j][9] = $templateSheet->getCellByColumnAndRow(10, $i);
$finalArr1[$j][10] = $dataArray[16+$j]['D'];
$finalArr1[$j][11] = $templateSheet->getCellByColumnAndRow(12, $i);
$finalArr1[$j][12] = $templateSheet->getCellByColumnAndRow(13, $i);
$finalArr1[$j][13] = $dataArray[16+$j]['C'];
$finalArr1[$j][14] = $templateSheet->getCellByColumnAndRow(15, $i);
$finalArr2[$j][0] = $templateSheet->getCellByColumnAndRow(18, $i);
$finalArr3[$j][0] = $templateSheet->getCellByColumnAndRow(23, $i);
$finalArr4[$j][0] = $templateSheet->getCellByColumnAndRow(25, $i);
$finalArr4[$j][1] = $dataArray[16+$j]['D'];
if($dataArray[16+$j]['J'] !='' and $dataArray[16+$j+1]['J'] == '' and $dataArray[16+$j+1]['A'] != ''){
$finalArr5[$j][0] = trim($dataArray[16+$j]['J']) / 2;
}else if($dataArray[16+$j]['J'] != '' and $dataArray[16+$j+1]['J'] != ''){
$finalArr5[$j][0] = trim($dataArray[16+$j]['J']);
}else if($dataArray[16+$j]['J'] == ''){
$finalArr5[$j][0] = trim($dataArray[16+$j - 1]['J']) / 2;
}else{
$finalArr5[$j][0] = trim($dataArray[16+$j]['J']);
}
$finalArr6[$j][0] = $date.sprintf("%02d",$sequenceNumber);
$finalArr6[$j][1] = $date;
$finalArr6[$j][2] = date('Ymd',strtotime($shipmentDate));
$finalArr6[$j][3] = '';
$finalArr6[$j][4] = date('Ymd',strtotime('+5 day'));
$finalArr7[$j][0] = $dataArray[16+$j]['C'];
$finalArr8[$j][0] = $templateSheet->getCellByColumnAndRow(125, $i);
$str1 = implode(';', $finalArr1[$j]);
$str2 = implode(';', $finalArr2[$j]);
$str3 = implode(';', $finalArr3[$j]);
$str4 = implode(';', $finalArr4[$j]);
$str5 = implode(';', $finalArr5[$j]);
$str6 = implode(';', $finalArr6[$j]);
$str7 = implode(';', $finalArr7[$j]);
$str8 = implode(';', $finalArr8[$j]);
$finalStr = $str1.';;;'.$str2.';;;;;'.$str3.';;'.$str4.';;;;;'.$str5.';;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;'.$str7.';;;;;;;;'.$str6.';;;;;;;;;;;;;;;;;;;;;;;;'.$str8;
$finalStrArr[][0] = $finalStr;
}
}
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->fromArray($finalStrArr, NULL, 'A1');
$newFileName = 'Test' .$date.sprintf("%02d",$sequenceNumber).'.csv';
$newFilePath = '../Generated_Files/' . $newFileName;
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
$writer->save($newFilePath); |
Beta Was this translation helpful? Give feedback.
Answered by
Lydiachl
Apr 22, 2022
Replies: 1 comment
-
Problem solved, I've read the documentation again and find the solution. $writer->setEnclosureRequired(false); |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
Lydiachl
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Problem solved, I've read the documentation again and find the solution.