Export to Excel

[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

[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.

[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!

[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.

[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?

[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.

[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.

[Alex K.]

Hello,

Please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.

Thank you.

[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 ... &param1=15
(useful params: 10 or 15)

[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.