Wpf Excel
-
Whenever I can write the excel file from stored procedure but one field size is 12 digit.so It can return exponential number.How to return these actual number?
-
Whenever I can write the excel file from stored procedure but one field size is 12 digit.so It can return exponential number.How to return these actual number?
-
Whenever I can write the excel file from stored procedure but one field size is 12 digit.so It can return exponential number.How to return these actual number?
I think that you will find it is actually returning the number. Select the cell in the spreadsheet and look at the value in the formula bar. That should have the digits in it. The issue is that the default display for a large number is as an exponential format but the display is not what is actually stored. Try, as a counter test, writing a (say) 15 digit number in a cell and then move to another cell then look at what the cell you wrote into has as its displayed value. Update: You can 'see' longer numbers in non-exponential format. Right click the cell(s), select Format Cells, Number tab / Category Number, set Decimal places to 0.