How to keep leading zeros while exporting excel

Shahid Salaam Khan

9y8.5kLearn iOS Programming

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi,
Please use this link which will help you,
https://www.aspsnippets.com/Articles/Export-GridView-To-WordExcelPDFCSV-in-ASP.Net.aspx
Rijwan Ansari5y ago
@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
Kiran Mohanty5y ago
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 Shah5y ago
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 = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + "=\"" + dr[i].ToString() + "\"");
tab = "\t";
}
Response.Write("\n");
}
Response.End();
Shahid Salaam Khan9y ago
I want excel to look like
Midhun Tp9y ago
Hi,

Try adding a "\t" or " " before the values having leading 0's.

Reference :

https://stackoverflow.com/questions/11574840/export-excel-avoid-stripping-the-leading-zeros
Rafnas T P9y ago
hi,
can you explain what you need exactly