EXCEL Export

Finance and Operations/AX Developer Forum
1

I need to export the EXCEL File.I don’t know how to code it.Can any one share the codings and explanation…?

Thanks in Advance,

Saju.K.

2

Please give detail what exactly you want to do.

there are so many things you can export to excel. Like report, Tables, form data etc.

3

Hai saju,

Even though i don’t know the solution.But when am searching in one book i find one code.If it is useful take it

ImpExpFileDialog class

This is the dialog class that is common for all the different import/export entities.

You do not need to change this class when adding a new entity class. Change this class only if you would like the dialog to look different or want to add additional fields to the dialog.

classDeclaration

This class provides the starting point for the

ImpExpFile

classes by presenting a dialog for the user, creating an object of the

ImpExpFile

class hierarchy, and then passing control to the created object.

class ImpExpFileDialog extends RunBase

{

// Global variables

FileName fileName;

FileType fileType;

FileEntity entity;

ReadWrite readWrite;

Dialog dialog;

// Dialog fields

DialogField dialogFileName;

DialogField dialogFileType;

DialogField dialogEntity;

DialogField dialogReadWrite;

#define.CurrentVersion(1)

// Macro that contains the global variables

// to be kept until the next time the user

// executes this class.

#localmacro.CurrentList

fileName,

fileType,

entity,

readWrite

#endmacro

}

Thanks & Regards

Naresh.D

4

Hi Naresh,

Can u tell me what is the use of COM class…?

Thanks in advance,

Saju.K

5

Hi Rajesh,

I want Export/Import from the Table…

Thanks in advance,

Saju.K

6

Hi Saju

If I am correctly understood you want to export data from the tables directly right?

You can do that through excel templates wizards in the Administration>periodic>ExcelSpreadSheet>templates wizard.

Just open the wizards. select the tables you want to export>give name of the file>Mark export data, and you will see your table exported with the data.

7

see the code example in this link,

http://patrikluca.blogspot.com/2009/08/export-to-excel-with-x-code.html