KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

EXPORT TO EXCEL #3038

Open Augustine Arthur opened this topic on on Apr 21, 2023 - 2 comments

Augustine Arthur commented on Apr 21, 2023

My report is generated from Mysql Datasource. It includes Bar Chart and Line Chart. In the export.php file, the excel extention is set to export.xlsx. When I click on export I get the message:

Please any assistance?.

When I changed the excel extension to export.xls, the result was gibberish:

Sebastian Morales commented on Apr 26, 2023

Your exported excel file is not formatted correctly because of warning message strings at the beginning. Pls make sure that your chart's datasource has the following condition:

1 . There's at least of row of data 2 . Column names are all correct case sensitively 3 . The first column must be of type string/datetime and the rest ones must be of type number.

Augustine Arthur commented on Apr 27, 2023

Thank you. I will let you know the outcome.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None