How to Increase Speed of Automation in Excel Report

Business Central/NAV Developers Forum
1

Hi,

i have develop a report(processing only) for showing data in excel sheet ,i have use Automation for excel sheet,but data are display very slow in Excel sheet ,how to increase speed of Excel using Automation. please suggest some answer…

Thanks.

2

Hi,
You need to look at your program/logic written on report.

3

Thanks to Response. it prints record in excel one by one , where i put Automation speed code.

4

Hi,
If you are using 2013 or later then either use default Save as Excel function after creating a layout or try to use Excel buffer table. You can find it in some standard reports which uses Excel Buffer table for Print to excel.It would be faster than automation.
If you are using 2009 or previous also you can try using Excel buffer table, I think it should work faster than automations.

5

Hi Binil,
Of course he should be using the Excel buffer, if he can. But the excel buffer is also using the automation’s to create the actual Excel files.

[mention:15b76258845848d89de519791396ecba:e9ed411860ed4f2ba0265705b8793d05], the buffer/automation isn’t very fast in general. Optimizing your code may not do enough for you, if you need to export a large number of records on a daily basis, then I would try to find a solution that works faster. And unless you need a lot of fancy formatting, then one way could be to export it as CSV and create a macro in Excel to import and format it the way you need it.

6

I believe using Automatons to export report is much faster in itself as compared of using Excel Buffer and then Export. Whats the export time you are facing