simplexls icon indicating copy to clipboard operation
simplexls copied to clipboard

Can't define the datetime format

Open ceininger opened this issue 2 years ago • 1 comments

Hey! I'm using your library to import data from XLS document and it seems that the setDateTimeFormat() method have no effect on the output of the row() method.

The problem is that the content of the $datetimeFormat attribute is used during the parsing (before the object is fully instantiated) and we can't parse the content of the file afterward.

Maybe the parse of the file should occur at the rows() or rowsEx() call and not during the instantiation of the object?

ceininger avatar Oct 10 '23 14:10 ceininger

Don't use $datetimeFormat for now use gmdate('d.m.Y', strtotime($value.'UTC')) for output date

shuchkin avatar Oct 10 '23 20:10 shuchkin