Patrick Aleman Patrick Aleman - 1 year ago 171
C# Question

CSV with EPPlus parsing issues

I am using EPPlus to read data.
This data consists of either a


When the file is a
file I use the
But EPPlus decides that it also has to parse all the values, which it shouldn't.

For instance:


ExcelTextFormat format = new ExcelTextFormat();
format.Delimiter = ';';
worksheet.Cells[1, 1].LoadFromText( "file", format );

Result is that the
value becomes:
in the worksheet. This i found out is because EPPlus sees the -3,88 as a number and parses it as a number with the default culture being
which in this case is (similar to)

How can i achieve that EPPlus loads the csv without parsing? (takes all values as strings)

Answer Source

It seems that EPPlus always parses imported data with the en-US format. So first import the column with the decimal values as a string. That way there is no attempt at conversion.

ExcelTextFormat format = new ExcelTextFormat
    Delimiter = ';',
    DataTypes = new eDataTypes[] { eDataTypes.Number, eDataTypes.String }

And after the values are imported with the correct decimal separators for your localization, loop the values, convert them to decimal and set the correct number format.

int columnNumber = 2;

for (int i = 2; i <= rowCount; i++)
    worksheet.Cells[i, columnNumber].Style.Numberformat.Format = "0.00";
    worksheet.Cells[i, columnNumber].Value = Convert.ToDecimal(worksheet.Cells[i, columnNumber].Value);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download