1 | <?php |
||||
2 | |||||
3 | use PhpOffice\PhpSpreadsheet\IOFactory; |
||||
4 | |||||
5 | require __DIR__ . '/../Header.php'; |
||||
6 | $spreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php'; |
||||
7 | |||||
8 | $helper->log('Write to CSV format'); |
||||
9 | $writer = IOFactory::createWriter($spreadsheet, 'Csv')->setDelimiter(',') |
||||
0 ignored issues
–
show
Bug
introduced
by
Loading history...
|
|||||
10 | ->setEnclosure('"') |
||||
11 | ->setSheetIndex(0); |
||||
12 | |||||
13 | $callStartTime = microtime(true); |
||||
14 | $filename = $helper->getTemporaryFilename('csv'); |
||||
15 | $writer->save($filename); |
||||
16 | $helper->logWrite($writer, $filename, $callStartTime); |
||||
17 | |||||
18 | $helper->log('Read from CSV format'); |
||||
19 | |||||
20 | $reader = IOFactory::createReader('Csv')->setDelimiter(',') |
||||
0 ignored issues
–
show
The method
setDelimiter() does not exist on PhpOffice\PhpSpreadsheet\Reader\IReader . It seems like you code against a sub-type of PhpOffice\PhpSpreadsheet\Reader\IReader such as PhpOffice\PhpSpreadsheet\Reader\Csv .
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
Loading history...
|
|||||
21 | ->setEnclosure('"') |
||||
22 | ->setSheetIndex(0); |
||||
23 | |||||
24 | $callStartTime = microtime(true); |
||||
25 | $spreadsheetFromCSV = $reader->load($filename); |
||||
26 | $helper->logRead('Csv', $filename, $callStartTime); |
||||
27 | |||||
28 | // Write Xlsx |
||||
29 | $helper->write($spreadsheetFromCSV, __FILE__, ['Xlsx']); |
||||
30 | |||||
31 | // Write CSV |
||||
32 | $filenameCSV = $helper->getFilename(__FILE__, 'csv'); |
||||
33 | $writerCSV = IOFactory::createWriter($spreadsheetFromCSV, 'Csv'); |
||||
34 | $writerCSV->setExcelCompatibility(true); |
||||
35 | |||||
36 | $callStartTime = microtime(true); |
||||
37 | $writerCSV->save($filenameCSV); |
||||
38 | $helper->logWrite($writerCSV, $filenameCSV, $callStartTime); |
||||
39 |