[WD14] Export to Excel from report preview window needs a lot of time

Startbeitrag von Michael Drechsel am 07.10.2014 14:54

Hi,

I created a report (approx. 500 pages) and I click "export to excel". It takes for the report in the preview window only 2-3 minutes, the export to excel neeeds 30 min.

I tried iprintdestination(excel) to avoid the preview window, but thats not the solution.

Any ideas ?

Antworten:

Hi Michael

into a xls or xlsx ? Those are using different codes, obviously, and I think I remember one is much slower than the other.

Best regards

von Fabrice Harari - am 07.10.2014 15:02
Hi Michael,

I have designed a lot of my reports to display the results in a table that I fill with programming and then allow the use to dump to excel using TableToExcel. I typically allow the user to see the results in table and to play around with sorts prior to exporting but you could also make table invisible and automatically call TableToExcel when table is full. maybe this method might work for you.

Steve

von steve erts - am 07.10.2014 15:04
Hi Steve,

I tried this also, but it is not significant faster. The query and tablefill works quite fast, only the tabletoexcel needs a lot of time ...

von Michael Drechsel - am 07.10.2014 16:28
XLS, I am not sure if WD14 can export to XLSX ...

von Michael Drechsel - am 07.10.2014 16:28
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.