These are chat archives for PHPOffice/PhpSpreadsheet

Feb 2018
Bram Van der Sype
Feb 19 09:08
Hi, is it possible with the CsvWriter to format dates on save? I’m using PHPSpreadsheet to import an excel file, convert it to a CSV and then process it somewhere else. However, the legacy processing system can not handled the non formatted dates (e.g. it expects 20180-2-16 instead of 43147)
rewriting the legacy csv handling isn’t an option right now.
Bram Van der Sype
Feb 19 09:14
Ah, answering my own question, it appears setting $spreadsheetReader->setReadDataOnly(false); on the reader was enough.
Adrien Crivelli
Feb 19 18:26
@Brammm you should have a look at advanced value binder