DataSource doesn't get all data from an "Excel"
Posted: Wed Aug 03, 2022 7:54 am
Hello, I have a question.
We have the typical PHP function that returns an HTML table and convert it to an .xls file with no libraries.
The fact is that some files work well when we load the files into the DataSource.
But in my case there's one that only load one column.
In the samples I attached you can see it. If you try to load the Test1.xls file you will see that only loads the Hours column but no the Date one.
But also in the Test2.xls works all well.
Could you help me to find a way to solve the problem with that column?
It only works well when I add some text in the box of the Date column.
We have the typical PHP function that returns an HTML table and convert it to an .xls file with no libraries.
The fact is that some files work well when we load the files into the DataSource.
But in my case there's one that only load one column.
In the samples I attached you can see it. If you try to load the Test1.xls file you will see that only loads the Hours column but no the Date one.
But also in the Test2.xls works all well.
Could you help me to find a way to solve the problem with that column?
It only works well when I add some text in the box of the Date column.