Export to Excel using C#

Question

I'm exporting the values in the grid to excel through C# code. When i open the exported excel, the string column is displayed as integer and the leading '0' in that field gets deleted. how to handle this.

What's the library that you're using for creating the excel file? — evasilchenko
– evasilchenko, Commented Mar 8, 2012 at 20:12

jrummell · Accepted Answer · 2012-03-08 20:10:07Z

1

This isn't a programming issue; it's Excel's default way of displaying what it thinks are numbers.

It assumes that 00001 is a number and should be displayed as 1. Change your cells to display "Text" instead of numbers in Excel.

answered Mar 8, 2012 at 20:10

jrummell

43.2k18 gold badges116 silver badges179 bronze badges

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

Comments

Casperah · Accepted Answer · 2012-03-08 20:11:52Z

0

I have no experience in making Excel files but when entering text in Excel you can write '00123. The ' makes the whole difference.

answered Mar 8, 2012 at 20:11

Casperah

4,5841 gold badge21 silver badges13 bronze badges

Comments

Hupperware · Accepted Answer · 2012-03-08 20:20:24Z

0

Style the TDs with mso-number-format:\@

answered Mar 8, 2012 at 20:20

Hupperware

9791 gold badge6 silver badges15 bronze badges

Comments

Basic · Accepted Answer · 2012-07-25 17:42:13Z

0

A quick way to get around this is to prefix your cell value with an apostrophe.

Excel hides the apostrophe automatically and forces the text mode for the cell to Text

Try it directly in Excel and you'll see what I mean eg type '07799123477 into a cell with General text formatting (the default)

answered Jul 25, 2012 at 17:42

Basic

26.9k29 gold badges122 silver badges209 bronze badges

Collectives™ on Stack Overflow

Export to Excel using C#

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related