Thursday, June 19, 2008

Export Data to Microsoft Excel from Axapta Super() Fast

When using SysExcelApplication Class for write or export data to Microsoft Excel from Microsft Dynamics Axapta, it take about 15 minutes to export 4000 records (that sucks dud ~_~").

There is several ways to make it faster, this tutorial will lead you to export 4000 records in just 5 seconds (Woogggghhh cool ^_^").

This how it's work, write the data you want to export to a clipboard then open Excel application using SysExcelApplication (SysExcelApplication class just use for opening excel application ^_^") then paste the clipboard, and this is the code :





Good luck brother ;P