Duration (min., sec.) 2:24 4:20 4:20 4:20 3:54
Duration(min., sec.) 0.1 0.180555556 0.180555556 0.180555556 0.1625
function convertXLStoCSV($infile, $outfile) // the function that converts the file { $fileType = PHPExcel_IOFactory::identify($infile); $objReader = PHPExcel_IOFactory::createReader($fileType); $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($infile); $writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV'); $writer->setDelimiter(","); //$writer->setEnclosure(""); //$writer->save("test123.csv"); foreach ($objPHPExcel->getWorksheetIterator() as $workSheetIndex => $worksheet) { $objPHPExcel->setActiveSheetIndex($workSheetIndex); $writer->setSheetIndex($workSheetIndex); $writer->save('converted/' . $outfile ."_" . $worksheet->getTitle() . ".csv"); }
$writer->setDelimiter(","); $writer->setEnclosure("");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)