Generating excel with datareader ignores DynamicExcelColumn "Ignore" property

[ogniben]

Excel Type

XLSX

MiniExcel Version

1.31.3

Description

Problem is: generating excel with datareader ignores DynamicExcelColumn "Ignore" property Code is like this:

            OpenXmlConfiguration excelconfig = new OpenXmlConfiguration
            {
                DynamicColumns = new DynamicExcelColumn[] { 
                    new DynamicExcelColumn("Id"){Ignore=true}
                },
                TableStyles = TableStyles.Default,
                AutoFilter = true,   
                EnableWriteNullValueCell = true, 
                FastMode = true
            };
                    var cmd = new SqlCommand();
                    ...
                    cmd.CommandText = sql;
                    using (var reader = await cmd.ExecuteReaderAsync())
                    {
                        var memoryStream = new MemoryStream();
                        await MiniExcel.SaveAsAsync(memoryStream, reader,true,sheetname,ExcelType.XLSX, excelconfig);

In the resulting excel the column "Id" is present, it's not ignored.