M
M
mbhusty2019-12-23 18:16:56
PHP
mbhusty, 2019-12-23 18:16:56

How to find out if a cell has a date value using PHPExcel?

The problem is that in the Date format, the values ​​come in the form of an integer, for example - 43811
How to find out that the date is stored in the cell?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
mbhusty, 2019-12-25
@mbhusty

Who cares, you can use the isDateTime function for each cell and check the format. The only negative is that the file must be opened in ReadDataOnly = false mode
$objReader->setReadDataOnly(false);

X
xmoonlight, 2019-12-23
@xmoonlight

Based on the general list of columns, by the elimination method and with further verification for the correct date.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question