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
- before or after adding values to cells?
2.) how do I automate this "convert to number"?
Thanks in advance
c#Buddy
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
Code:
worksheet.cells[row,column].NumberFormat = "#.##0.00";
2.) how do I automate this "convert to number"?
Thanks in advance
c#Buddy