All Questions
4 questions
1
vote
1
answer
527
views
Excel scientific notation converting numeric value to E+ characters
Excel scientific notation converting numeric value to E+ characters. How to handle this in excel parcing in c#? im expecting it as string value.for example my input is '123456789012345678901234567890' ...
- 57
0
votes
1
answer
2k
views
Change the Format of an Excel Column programmatically and prevent scientific Notation like exponent (E) in nubmber fields
i am generating an Excel from DataSet using the following code
int ColumnsCount;
if (DataTable == null || (ColumnsCount = DataTable.Columns.Count) == 0)
throw new Exception("...
- 446
2
votes
1
answer
2k
views
Reading excel from c#, converts long numbers to exponential values
I am reading the Excel having a column of long numeric values of more than 8 digit. It also may start from 0 for example 003787677. Examples in my case are 173370148, 142350093 etc.
The values in ...
- 23
0
votes
1
answer
2k
views
Formating programmatically Excel cells from Scientific numeric to Text with C#
I'm facing a problem after extracting data from my sqlServer dataBase to my Excel worksheet using Microsoft.Office.Interop.Excel reference. Numeric data are displayed in a scientific numeric format, ...
- 359