Page 1 of 2
Export to Excel
Posted: Fri Nov 04, 2016 7:40 am
by dkolar
HY! I'm using Stimulsoft FX For PHP for 2 years now in various projects. Until now, all my reports were generated in PDF.
Now I need to export my data in Excel, but I can do that only as images?
I would like to export my formated data in excel report as data
Is this possible with Reports.PHP 2015.1?
Thank you
Re: Export to Excel
Posted: Fri Nov 04, 2016 1:31 pm
by Alex K.
Hello,
Please try to set the Allow HTML Tags property to false for Text components.
Also, please check the 2016.2 version, in which HTML tags will be exported as text.
Thank you.
Re: Export to Excel
Posted: Mon Nov 07, 2016 8:01 pm
by dkolar
Thanks a lot.
Now it's working perfectly.
My next question is speed of the Data loading and report rendering as well as export time.
I have a report with around 500 pages (the same I attached) and the data loading + report rendering is around 2 minutes. Can it be shortened?
I'm not using cache, because it's even slower.
How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
Thank you for your answers!
Re: Export to Excel
Posted: Tue Nov 08, 2016 8:41 pm
by Alex K.
Hello,
You can try to optimize your report:
https://www.stimulsoft.com/ru/blog/arti ... ng-reports
https://www.stimulsoft.com/ru/blog/arti ... rts-part-2
https://www.stimulsoft.com/ru/blog/arti ... rts-part-3
> How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
This error occurs only with this report or with any others?
Thank you.
Re: Export to Excel
Posted: Wed Nov 09, 2016 10:03 am
by dkolar
I have read that...and even after optimisation it's significantly slower than other report tools (based od .NET technology).
Regardless Export, I figure out that there is some kind of problem if too many page are selected for Export. If my report, for example, has <200 page, I can export it in 5-10 seconds. Is there some 'session timeout', so bigger report cannot be exported?
Re: Export to Excel
Posted: Wed Nov 09, 2016 12:19 pm
by Alex K.
Hello,
Please check the last build. In one of the last version (after 2015.1) was fixed a problem with the flash player update.
Also, please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Re: Export to Excel
Posted: Wed Nov 09, 2016 4:15 pm
by dkolar
Aleksey, thank you.
Now it works on localhost. However, if I try to load viewer / report on my webserver via remote access, it renders indefinitely?
Other reports works fine.
If you need that, I can set up my web server so will have 'live' access to report?
I'm sending you .mrt file in attachment.
Re: Export to Excel
Posted: Fri Nov 11, 2016 6:59 am
by Alex K.
Hello,
Please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Re: Export to Excel
Posted: Fri Nov 11, 2016 9:30 am
by dkolar
Aleksey, thank you for your reply.
You can find report attached.
Also, you can check that report with live data on following link:
http://onto.smart-step.hr/stimulsoft/in ... ¶m1=15
(useful params: 10 or 15)
Re: Export to Excel
Posted: Mon Nov 14, 2016 8:18 pm
by Alex K.
Hello,
You send the report template again.
Could you save your rendered report and send us a .mdc file for analysis:
Code: Select all
report.Load();
report.Render(false);
report.SaveDocument("report.mdc");
Thank you.