PHP Snippet 1:
$excel = 'excelfile.xlsx';
$name = 'newCsvName';
$reader = new Xlsx();
$reader->setReadDataOnly(true);
$sheets = $reader->listWorksheetNames($excel);
foreach($sheets as $sheet){
$spreadsheet = $reader->load($excel);
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
$writer->setDelimiter(";");
$csvPath = 'csv_files/' . $dir . '/' . $name.'_'.$sheet.'.csv';
$writer->save($csvPath);
}
PHP Snippet 2:
$reader->setLoadSheetsOnly([$sheet]);
PHP Snippet 3:
$excel = 'excelfile.xlsx';
$name = 'newCsvName';
$reader = new Xlsx();
$reader->setReadDataOnly(true);
$sheets = $reader->listWorksheetNames($excel);
foreach($sheets as $sheet){
$reader->setLoadSheetsOnly([$sheet]);
$spreadsheet = $reader->load($excel);
$writer = new \PhpOffice\PhpSpreadsheet\Writer\Csv($spreadsheet);
$writer->setDelimiter(";");
$csvPath = 'csv_files/' . $dir . '/' . $name.'_'.$sheet.'.csv';
$writer->save($csvPath);
}