Importing Data into Excel

[cSharpBuddy]

Hello everyone,

I've read some logfiles to import their data into a statistics (excel) file. Now I ran into trouble that within excel the cell's format is "number" but it is still displayed as string/text, causing my diagramm is not updated until I apply "convert to number" to all concerning cells, though all cells are formatted as number under cell format properties.

1.) when do I use the number format

worksheet.cells[row,column].NumberFormat = "#.##0.00";

- before or after adding values to cells?
2.) how do I automate this "convert to number"?

Thanks in advance
c#Buddy