How to convert column datatyp in excel to String using C#

Question

Hello,

I have to convert the column datatype in Excel to String. The column contains scientific notation. Once I used NumberFormat to convert it, the scientific notation is not expanded. Can someone help? I need code. Thanks.
Oker

Answer 1

Is there any difference between getting the scientific notation form and getting the ordinary number form?

We can easily convert them to each other with c#.

            decimal h = Decimal.Parse( cellValue.ToString(), NumberStyles.Any, CultureInfo.InvariantCulture);  

Moreover, even if it is converted to Text type, its value still is the correct number. Is it different in your case?

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.