Skip to content

Exporting Data to an Excel Using X++ in Dynamics 365 for Operations

Here in D365 we don’t have SysExcelApplication, we can use OfficeOpenXml Namespace achieve export functionality

 using System.IO;
    using OfficeOpenXml;
    using OfficeOpenXml.Style;
    using OfficeOpenXml.Table;
    class CustExport
    {
             public static void main(Args   _args)
        {

            CustTable custTable;
            MemoryStream memoryStream = new MemoryStream();
 using (var package = new ExcelPackage(memoryStream))
            {
                var currentRow = 1;
var worksheets = package.get_Workbook().get_Worksheets();
                var CustTableWorksheet = worksheets.Add("Export");
                var cells = CustTableWorksheet.get_Cells();
                OfficeOpenXml.ExcelRange cell = cells.get_Item(currentRow, 1);
                System.String value = "Account Number";
                cell.set_Value(value);
                cell = null;
                value = "Currency";
                cell = cells.get_Item(currentRow, 2);
                cell.set_Value(value);
while select CustTable
                {
                    currentRow ++;
                    cell = null;
cell = cells.get_Item(currentRow, 1);
                    cell.set_Value(CustTable.AccountNum);
                    cell = null;
cell = cells.get_Item(currentRow, 2);
                    cell.set_Value(CustTable.Currency);
                }
                package.Save();
                file::SendFileToUser(memoryStream, "Test");
            }
        }
}

           

               

               

                   

                   

Published inUncategorized