大数据量.Net使用OpenXml导出Excel

1、使用NuGet包管理器安装

DocumentFormat.OpenXml

2.调用导出方法

    /// <summary>
    /// 导出Excel
    /// </summary>
    /// <param name="fileName">保存文件路径</param>
    /// <param name="exportTable">数据源</param>
    private static void ExportExcelFile(string fileName, DataTable exportTable)
    {
        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook))
        {
            WorkbookPart workbookPart = spreadsheetDocument.AddWorkbookPart();
            workbookPart.Workbook = new Workbook();

            WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>();
            var sheetData = new SheetData();
            worksheetPart.Worksheet = new Worksheet(sheetData);

            Sheets sheets = workbookPart.Workbook.AppendChild(new She