empty cells were skipped in the excel to csv conversion

Topics: Developer Forum
Feb 24, 2011 at 10:32 AM

I try to convert a xls file to a csv file with the following code

$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

$objWriter = new PHPExcel_Writer_CSV($objPHPExcel);
$objWriter->setDelimiter($delimiter);
$objWriter->setEnclosure('');
$objWriter->setLineEnding("\r\n");
$objWriter->setSheetIndex(0);

// save the csv file
$objWriter->save($outputFileName);

If there is four columns and three lines in the input file like (the cell mobile is empty in the last line)

forename surname mobile city

jack Smith 067...90 Atlanta

joe Black New York

After the conversion, the city New York is in the mobile column.

Php version is 5.2.9

PhpExcel version is 1.7.5

Thanks in advance for the response

 

Feb 24, 2011 at 3:14 PM

The changeset 69208 solves the problem.

Great Work