Keep numeric format using Cells.LoadFromText method

Jan 18, 2013 at 11:12 AM

Hi. I want to load a string that contains scientific number values (e.g.  2,80414e+000) into a sheet using:

sheet.Cells["A1"].LoadFromText(textString,TextFormat);

The rest of the data is loaded right but the scientific value format changes (e.g. 2,80) .

I tried to set the format with 

sheet.Cells.Style.Numberformat.Format = "##0.0E+000";

but this data string has integer values that should not be converted. 

Is there any way to load the data avoiding using a loop running over each cell setting the format?

Thanks