XLSX to CSV - Callback function mode
The data needs to be written to CSV after secondary processing.
- 1.Many xlsx file fragments are merged into a single CSV file for unified processing;
- 2.The speed of adding xlsx files is greater than the speed of task processing. After asynchronously converting files to CSV, you can use more efficient tools to process them (for example, the database tool directly imports CSV)
More application scenarios are waiting for you to discover ...
putCSVCallback(callable $callback, resource $handler): bool
Return function
The file pointer must be valid and must point to a file successfully opened by fopen () or fsockopen () (and not yet closed by fclose ()).
$config = ['path' => './tests'];
$excel = new \Vtiful\Kernel\Excel ($config);
$filePath = $excel-> fileName('tutorial.xlsx', 'TestSheet1')
->header(['String', 'Int', 'Double'])
->data([
['Item_1', 10, 10.9999995],
])
->output ();
$fp = fopen ('./ tests / file.csv', 'w');
$csvResult = $excel->openFile('tutorial.xlsx')
->openSheet()
->putCSVCallback(function (array $row) {
return $row;
}, $fp);
Last modified 3yr ago