D365：导出数据到现有Excel或者创建新的Excel

打开现有的：

using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
/// <summary>
/// 
/// </summary>
class ExportClass
{
    public static void exportFile()
    {
        str                 tmpfile;
        str                 value;
        CustTable           custTable;
        FileInfo            templateFile;
        ExcelRange          cell;
        ExcelWorksheet      cells;
        MemoryStream        memoryStream = new MemoryStream();
        int                 currentRow = 3;
        

        ;
        //Get Resource temPlate
        tmpfile = '文件路径';
        //Convert to an IO stream
        templateFile = new System.IO.FileInfo(tmpfile);
        using (ExcelPackage filepackage = new ExcelPackage(templateFile))
        {
            
            // 获取模板第2个sheet
            cells = filepackage.Workbook.Worksheets.get_Item(2);
            // 获取内存流
            memoryStream = filepackage.Stream;
            
            //set value
            cell = cells.get_Cells().get_Item(1, 2);
            cell.value = '1';
            cell = cells.get_Cells().get_Item(1, 4);
            cell.value = '2';
            cell = cells.get_Cells().get_Item(1, 6);
            cell.value = '3';    

           
            filepackage.Save();
            file::SendFileToUser(memoryStream,'ExportExcelFile.xlsx');
        }
           
    }

}

创建新的

using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;
class SRWriteToExcel
{
    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.xlsx');
           
        }
       
    }

}