Get xls datetime as number

[topmet]

get all data from worksheet as ..... ->toArray(null, true, true, true);

Cell in xls file "01.03.2023 10:57:06" get in ->toArray(null, true, true, true); "44986.456319444"

How to fix it ?

O

[MarkBaker]

This should work: what version of PhpSpreadsheet are you using?

Or are you loading a file and telling the Reader to read Data Only?

[topmet]

1.28.0
php 7.4

`$inputFileType = 'Xls';
$inputFileName = $A['file']['xls'];

$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);

$reader->setReadDataOnly(true);

$spreadsheet = $reader->load($inputFileName);
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);`

can't load file (

[MarkBaker]

You do realise that $reader->setReadDataOnly(true); is telling the Reader to load only the raw data from the worksheet, and not to load the formatting information for cells?

The value that looks like 01.03.2023 10:57:06 in the Excel cell is an Excel serialized timestamp, a numeric value (44986.456319444) with a number format mask that tells Excel to display it like a date.
When you do $reader->setReadDataOnly(true);, you're telling PhpSpreadsheet to load the value (44986.456319444), but not to load the number format mask.

See the documentation here

[topmet]

omg, thanks, work fine