DataSource doesn't get all data from an "Excel"

Stimulsoft Dashboards.WEB discussion
Post Reply
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

DataSource doesn't get all data from an "Excel"

Post by ArnauINFR »

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.
Attachments
Test.zip
(419 Bytes) Downloaded 103 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: DataSource doesn't get all data from an "Excel"

Post by Lech Kulikowski »

Hello,

How do you add these files to the report?

Thank you.
ArnauINFR
Posts: 21
Joined: Fri Nov 05, 2021 10:01 am

Re: DataSource doesn't get all data from an "Excel"

Post by ArnauINFR »

Hello, I have added the files clicking to the Excel files and then setting the url of my server where the files saved.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: DataSource doesn't get all data from an "Excel"

Post by Lech Kulikowski »

Hello,

It is not an excel file. It is just HTML saved as .xls.

Thank you.
Attachments
Screenshot 2022-08-05 120724.png
Screenshot 2022-08-05 120724.png (36.9 KiB) Viewed 1100 times
Post Reply