configuration is not used when writing using IDataReader

[rferraton]

Excel Type

• XLSX
• XLSM
• CSV
• OTHER

Upload Excel File

mssql_orders.xlsx

MiniExcel Version

1.38.0

Description

the configuration used when writing is not used :

 DbCommand sqr;
 sqr = DBCommonUtils.GetCommand(connectionType, inputsql, sqlConnection);

 var config = new OpenXmlConfiguration();
 config.BufferSize = 1024 * 1024 * 4;
 config.FastMode = true;
var nfib = new NumberFormatInfo();
nfib.NumberDecimalSeparator = ".";
var culture = (CultureInfo)CultureInfo.InvariantCulture.Clone();
culture.NumberFormat = nfib;                    
config.Culture = culture;
config.EnableAutoWidth = true;

using (var sdr = sqr.ExecuteReader())
{
    MiniExcel.Insert(FullFileName, sdr, sheetName: p.sourcetable, overwriteSheet: true, configuration:config);
    ccols = sdr.FieldCount;
    crows = 0; // waiting for rowcount attribute feature on Insert						
}

[michelebastione]

Could you please verify whether the same issue occurs if you pass a sample of the data inside an IEnumerable<object> instead of passing the IDataReader directly?

[izanhzh]

Could you please also verify if SaveAs has the same issue ? At present, Insert and SaveAs write cell values in the same logic, and please check whether your data is a numeric type, not a string

[rferraton]

Could you please also verify if SaveAs has the same issue ? At present, Insert and SaveAs write cell values in the same logic, and please check whether your data is a numeric type, not a string

SaveAs seams to use the config.

the data generated using a save as with the same config :

orders.xlsx

[michelebastione]

Could you please provide the exact database types of the table you're reading from? And whether or not they can be null?

[rferraton]

Sure : the data come from sql server :

CREATE TABLE [dbo].[orders](
	[o_orderdate] [date] NULL,
	[o_orderkey] [bigint] NOT NULL,
	[o_custkey] [bigint] NOT NULL,
	[o_orderpriority] [char](15) NULL,
	[o_shippriority] [int] NULL,
	[o_clerk] [char](15) NULL,
	[o_orderstatus] [char](1) NULL,
	[o_totalprice] [money] NULL,
	[o_comment] [varchar](79) NULL
) 
GO

[michelebastione]

I found the reason. In the end it was trivial, the configuration was just not being passed as a parameter in the branching path handling the file not existing. Gonna make a PR right away.