C# Convert Number stored as Text to Number when exporting to Excel

Question

I export data from datagrid to Excel and one column with numbers is with error 'numbers stored as text'. I am trying to convert them using following code, but its not working. Could you suggest?

The problem is that then column headers are moved up and data is broken.

  worksheet.Range["E5", "E5"].EntireColumn.TextToColumns();
  worksheet.Columns[5].NumberFormat = "# ##0,00";

Problem shown

Store numbers not text to begin with. You aren't exporting to Excel with this code, you're using Excel Interop to actually start Excel and set values to fields. Instead of storing text to those values, store numbers - ints, decimals, doubles — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Dec 12, 2019 at 8:11
You didn't post the code that actually sets the values though — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Dec 12, 2019 at 8:11
This link may help you. cell in Excel “Number stored as text” — AnonymousKKYY
– AnonymousKKYY, Commented Dec 13, 2019 at 1:58

Dash_Xyz_Abc · Accepted Answer · 2020-05-11 05:59:01Z

1

This code converts numbers stored in text format to number format. If you want to use it to opposite direction set the fieldinfo to { 1, 2 }.

Range rng = Worksheet.Range["A1:A10""];

rng.TextToColumns(rng, XlTextParsingType.xlDelimited, XlTextQualifier.xlTextQualifierDoubleQuote, Tab: true, FieldInfo: new int[] { 1, 1 }, TrailingMinusNumbers: true);

answered May 11, 2020 at 5:59

Dash_Xyz_Abc

315 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# Convert Number stored as Text to Number when exporting to Excel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related