Microsoft Dynamics AX (Archived)

export ListView data to excel

(0) Share

Report

Posted on by 10GoX

i have problem, need to export ListView data to excel, can anyone help me?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

You have to write the customized code in order to achieve this functionality. I was also looking the same thing for user groups but did not find anything like this.

Was this reply helpful? Yes No
Amir Nazim 5,994 on at

Like (0)

Report

Hi,

Listview does not bind with the datasource, it is populated through some fill logic, if you know little bit of development, you can dig into the listview to find the source which is filling the listview. Once you know the source table which is filling the listview then you can use the Template wizard in Administration module to create the template of that table and can export data.

Was this reply helpful? Yes No
Suggested answer

Roshan N 190 on at

Like (0)

Report

Take a look into this.....

shekhardiptiman.wordpress.com/.../dynamics-ax-2009-exporting-data-to-excel-part1

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

In case someone else is looking for a solution to this.

While there may be a better way to do this, this is the solution I current use.

void function_exportToExcel(int controlId)
{
    formListControl             formListControl;
    formListColumn              formListColumn;
    SysExcelApplication         xlsApplication              = SysExcelApplication::construct();
    SysExcelWorkBooks           xlsWorkBookCollection       = xlsApplication.workbooks();
    SysExcelWorkBook            xlsWorkBook                 = xlsWorkBookCollection.add();
    SysExcelWorkSheets          xlsWorkSheetCollection      = xlsWorkBook.worksheets();
    SysExcelWorkSheet           xlsWorkSheet                = xlsWorkSheetCollection.itemFromNum(1);
    SysExcelRange               xlsRange;
    CustTable                   custTable;
    int                         row = 3;
    int                         rowData;
    int                         i, cols, idx;
    str                         fileName;
    formListNext                formListNext                = formListNext::All;
    formListItem                formListItem;
    ;

    formListControl = formRun.control(controlId);
    formListControl.lockWindowUpdate(true);

    cols             = formListControl.getColumnCount();
    for (i=0;i<cols;i++)
    {
        formListColumn = formListControl.getColumn(0);
        if (formListColumn)
        {
            xlsWorkSheet.cells().item(row,i+1).value(formListColumn.text());

            idx         = formListControl.getNextItem(formListNext);
            rowData     = row;
            while(idx != -1)
            {
                rowData++;

                formListItem        = formListControl.getItem(idx);
                idx                 = formListControl.getNextItem(formListNext, idx);

                xlsWorkSheet.cells().item(rowData,i+1).value(formListItem.text());
            }

            formListControl.deleteColumn(0);
        }
    }
    this.fill();

    formListControl.lockWindowUpdate(false);

    xlsApplication.visible(true);
}

Was this reply helpful? Yes No