This project has moved. For the latest updates, please go here.

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:


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?