What does this value mean 1,845E-07 in excel?

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....

+3
source share
2 answers

1.84E-07 - , , .

1,845E-07 0,0000001845. Excel , 0, 0, , .

# . ToString e- .

, e-.

+10

, , "", .

+1

Source: https://habr.com/ru/post/1744138/


All Articles