I am reading an excel sheet from C # using interop services. In my worksheet, the cell value is 0.00. but the runtime, when I check the value of this cell in C # code, I get this value "1.845E-07". When I check the Excel sheet, I right-clicked on that cell, say, in the format cell, I got the value "1.845E-07" in the sample section. How to get the exact value? Please help me. The code is huge, so I cannot provide it here. this line:
if (Convert.ToString(((Excel.Range)worksheet.Cells[iRowindex, colIndex_q10]).Value2) != string.Empty)
{
drRow[dtSourceEXLData.Columns[constants.Floor]] = ((Excel.Range)worksheet.Cells[iRowindex, colIndex_q10]).Value2.ToString();
}
Same issue with Date cells "39448". what does it mean? please, help....
source
share