How to keep leading zeros while exporting excel

Question

Rijwan Ansari · Answer

@Shahid, Check this if it can help How can I keep leading zeros in CSV files? (upenn.edu) https://provider.www.upenn.edu/computing/da/bo/webi/qna/iv_csvLeadingZeros.html

Jignesh Kumar · Answer

Hi, Please use this link which will help you, https://www.aspsnippets.com/Articles/Export-GridView-To-WordExcelPDFCSV-in-ASP.Net.aspx

Kiran Mohanty · Answer

Please follow below steps. 1.Select a cell(s) where you want to show leading zeros, and press Ctrl+1 to open the Format Cells dialog. 2.Under Category, select Custom. 3.Type a format code in the Type box. In most cases, you will need a format code consisting of 0 placeholders, like 00. The number of zeros in the format code corresponds to the total number of digits you want to show in a cell (you will find a few examples below). 4.Click OK to save the changes.

Jay Shah · Answer

Use below code as reference dt = getData(); //your datatable string attachment = "attachment; filename=data.xls" ; Response.ClearContent(); Response.AddHeader( "content-disposition" , attachment); Response.ContentType = "application/vnd.ms-excel" ; string tab = "" ; foreach (DataColumn dc in dt.Columns) { Response.Write(tab + dc.ColumnName); tab = "	" ; } Response.Write( "
" ); int i; foreach (DataRow dr in dt.Rows) { tab = "" ; for (i = 0; i { Response.Write(tab + "="" + dr[i].ToString() + """ ); tab = "	" ; } Response.Write( "
" ); } Response.End();

Shahid Salaam Khan · Answer

I want excel to look like

Midhun Tp · Answer

Hi, Try adding a "	" or " " before the values having leading 0's. Reference : https://stackoverflow.com/questions/11574840/export-excel-avoid-stripping-the-leading-zeros

Rafnas T P · Answer

hi, can you explain what you need exactly

How to keep leading zeros while exporting excel

Answers (7)