hii,
i generate the excel using Automation.
But their speed is very slow…my Purchase orders is more…
how can i increase the speed…?
i use the Progressbar…but that is not enough…
tell me what i can do?
Excel using Automation is slow, compared to other methods of importing/exporting data. Progress bar just makes it slower.
If you have large data amounts you want to transfer to Excel and the performance is “killing you”, then consider recoding it to use flat CSV files and use an Excel macro to import and display the data.
But…client does not want such type of scenario…then want…direct export to excel…with less time
So your client think that you can do magic? [;)]
If you have already optimized the hardware (ram, cpu etc.), and your code is optimized, then there is not much else you can do.
I cannot tell you if it is fast but you could also take a look at Excel buffer (https://blogs.msdn.microsoft.com/nav/2012/10/04/excel-buffer-using-open-xml-instead-of-excel-automation-part-1-of-2/)
That a good alternative option! [:)]
But as far as I remember, then [mention:d37e849211a549bdb70a00b394567ad1:e9ed411860ed4f2ba0265705b8793d05] uses NAV 2009 (always mention which version your question is about). And this was not available until NAV 2013.
no i am using 2016…and i have to use automation variable because i have to use size,color,alignment,font,Border…so i am using excel automation instead of excl buffer
Hi Expn,
Well then you can use the buffer table as suggested by Lars. Read both the first post (link in Lars’ reply) and the second:
blogs.msdn.microsoft.com/…/
The examples here shows you how to set colors etc. as well, using formats.
Ok. thanks…i will try with this
This post may also help you. Export from Excel buffer using .Net interop.
kauffmann.nl/…/
Hi Expn,
Please let us know if you were able to get it to export faster? (Click “This helped me” on the posts that were helpful to you).