Generate Excelsheet With Leading zeros using C#

Question

When I generate an Excel spreadsheet from C#, the account number column lost its leading zeros in the spreadsheet.

For example, if any row has the account number '00012345678', then when I generate the spreadsheet, it shows like '12345678'.

Please help me.

I try to put \t,\n,',etc. but no luck.

Please refer [excel not inserting leading zero](http://stackoverflow.com/questions/15143753/excel-not-inserting-leading-zero) — Balagurunathan Marimuthu, Sep 02 '16 at 07:40
I found a solution. Refer link: http://vimalvataliya.blogspot.in/2016/09/generate-excelsheet-with-leading-zeros.html — Vimal Vataliya, Sep 02 '16 at 09:58

score 1 · Answer 1 · answered Sep 02 '16 at 10:00

1

Excel is seeing the value as a number, which will drop the leading zero's. You will need to add the number as "Text", possibly specifying the data type or supplying the values with "quotes".

answered Sep 02 '16 at 10:00

Mark Redman

24,079
20
92
147

http://vimalvataliya.blogspot.in/2016/09/generate-excelsheet-with-leading-zeros.html i found a solution – Vimal Vataliya Sep 02 '16 at 10:17

Generate Excelsheet With Leading zeros using C#

1 Answers1