Create a generic method for export to excel

See more:

Dynamics-AX

Hi all,

I am developing a excel report in ax 2012. I have a temp table and a DP class which inserts the data into the temptable.

I need to write a method which is in the following format:

public void ExportToExcel( TableId tblid, str FilePath)
{
.
.
}

I need to pass the temptable id to the export method and generate the excel report.
I am able to get the table field names in the excel using dicttable.

dict = new DictTable(tblId);    

    for (i = 1; i<=dict.fieldCnt(); i++)
    {
        fieldId = dict.fieldCnt2Id(i);
        dictField = new DictField(tblid, fieldId);
        if(!dictField.isSystem())
        {
            fieldnames[i-1] = dictField.name();
            xlsWorkSheet.cells().item(row,i).value(dictField.label());
        }
    }

But I am not getting a way to get the table values.

The DictTable also gives the table properties only, but no clue on the table records.

Kindly help me getting the table data in the excel.

Thanks in advance,
Sruthi R