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

8 comments:

Banta said...

h! i ready your blog. i have a confussion. I'm a student i intersted in axapta. I am not expert but i have some knowledge of c,c++,Oracle,VB,HTML,DHTML how i start i don't know guide me.

regards

Alexis said...

In this sphere there is one of the best tools,which works with excel files and has free as far as I know-Excel recognizable format,it helped for me,and program will allow to avoid such error messages, like: xlsx this file is not in a recognizable format, xlsx file is not in a recognizable format or even this file is not in a recognizable version for Excel,help you to get rid of such messages: this file is not in a recognizable format Microsoft Excel, Microsoft Excel recognizable format and Microsoft Excel file is not in recognizable format,also tool will allow you to recover your files in Microsoft Excel format and avoid errors like: this file is not in a recognizable format xlsx, this file is not in a recognizable format xlsm, Microsoft Excel the file is not in a recognizable format, Microsoft Excel XP the file is not in recognizable format or even Excel file not in a recognizable format recovery.

Praveen said...

textbuffer.toClipboard() is throwing error "insufficient memory to perform the task" when the data is huge. Any idea how to fix this error?

aditya said...

hi all,

i have problem with importing excel to axapta through class
iam getting all the fields exact data but problem with time fields.
i tried to convert using sring functoin..
still getting "0000" place of time field in table..
so could any one help me out of this....
esriaditya@gmail.com
Thanks,
SriAditya

husna yusuf nawawi said...

hi ...
i've got some trouble here.
when i click button E-mail applicant at Application Detail form->Recruitment->Periodic->Human Resource i've got an error. the error said "DictField object not initialized" at class HRMApplicationbookmark/bookmarkandvalue. so i try to open that class and compile it. but there's no an error right there.

and it's happen to my Sysdictfield too. When i open my Application E-mail templete form->Recruitment->setup->Human Resource, then i click radio button for Interview, there's an error "Sysdictfield object not initialized" at class HRMApplicationemailtemplates/fillListViews ...

may be u know the answer. And thanks for the help. :)

Anonymous said...

If you want to learn Ms Excel call Excel Training NYC

Cardona said...

Sometime user can’t access Excel data after exporting data to Microsoft excel file. So, to repair xls file you can try Excel open & repair inbuilt utility. It’s free and easy to use. If it’s not working then you can try other resources like,

https://excelchamps.com/blog/5-effective-ways-quickly-repair-corrupt-excel-file/
https://www.microsoft.com/en-us/p/stellar-phoenix-excel-repair/9nblggh55858?activetab=pivot:overviewtab
https://www.stellarinfo.com/repair-excel-file.php

Anonymous said...

доброго здоровья

выдавивший из себя - Щебень Ротково https://sinonim.org/ за высокую цену?

где взять - за невысокую цену?

Подробнее: https://nerudnye-materialy.business.site/