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.
DataSource doesn't get all data from an "Excel"
DataSource doesn't get all data from an "Excel"
- Attachments
-
- Test.zip
- (419 Bytes) Downloaded 111 times
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: DataSource doesn't get all data from an "Excel"
Hello,
How do you add these files to the report?
Thank you.
How do you add these files to the report?
Thank you.
Re: DataSource doesn't get all data from an "Excel"
Hello, I have added the files clicking to the Excel files and then setting the url of my server where the files saved.
-
- Posts: 6265
- Joined: Tue Mar 20, 2018 5:34 am
Re: DataSource doesn't get all data from an "Excel"
Hello,
It is not an excel file. It is just HTML saved as .xls.
Thank you.
It is not an excel file. It is just HTML saved as .xls.
Thank you.
- Attachments
-
- Screenshot 2022-08-05 120724.png (36.9 KiB) Viewed 1183 times