Skip to content

Datatable动态导出Excel,IExporterHeaderFilter设置禁用表头筛选器无效 #566

Open
@us12548

Description

@us12548
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("ProductCode", typeof(string)));
        dt.Columns.Add(new DataColumn("ProductName", typeof(string)));
        dt.Columns.Add(new DataColumn("Quantity", typeof(string)));
        for (int i = 0; i < 10; i++)
        {
            var row = dt.NewRow();
            row["ProductCode"] = "ProductCode" + i.ToString();
            row["ProductName"] = "ProductName" + i.ToString();
            row["Quantity"] = "Quantity" + i.ToString();
            dt.Rows.Add(row);
        }
        IExcelExporter excelExporter = new ExcelExporter();
        //设置IExporterHeaderFilter为null无效
        var res = await excelExporter.ExportAsByteArray(dt,null);
        return new FileStreamResult(new MemoryStream(res), "application/octet-stream")
        {
            FileDownloadName = $"{DateTime.Now.ToString("yyyyMMdd")}.xlsx"
        };

还是有筛选器
17188696021728

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions