Export to Excel

Question

Dear All,      I want to export data from sql using asp.net. So i want to same value which is in database table in sql. So i want,   For ex.   If mobile no having data like 01234567899 in sql. when i export that data in excel using C#, so that column value in excel showing 1234567899. But i want that 0 alos while exporting data.   So plz help me on the same.How to overcome above scenario.   Thx in advance

Rajeev Punhani · Answer

Hi Rahul, Excel interprets the mobile number column as numeric so it removes the leading zero.To retain leading zero enclose the mobile number in a single quote so it will be considered as string. If the above solution is helpful then, accept the answer.

RAHUL PATIL · Answer

DataTable dt = new DataTable(); if (RD1.Checked == true) { dt = gen.getDataTable("select [BeneficiaryBank Name],BeneficiaryBranchName,BeneficiaryName,[BeneficiaryAccount No],BeneficiaryIFSC,Amount from vwneft where PaymentDate between '" + general.getdate(txtFromdate.Text) + " ' and ' " + general.getdate(txtEndDate.Text) + " " + "" + "23:59:00" + " '"); } else { dt = gen.getDataTable("select [BeneficiaryBank Name],BeneficiaryBranchName,BeneficiaryName,[BeneficiaryAccount No],BeneficiaryIFSC,Amount from vwneft"); } // DataTable dt = gen.getDataTable("select [BeneficiaryBank Name],BeneficiaryBranchName,BeneficiaryName,[BeneficiaryAccount No],BeneficiaryIFSC from vwneft"); if (dt.Rows.Count > 0) { Decimal dTotalPrice = 0; for (int j = 0;j { dTotalPrice += dt.Rows[j].Field (5); } string attachment = "attachment; filename=Approve_" + DateTime.Now + ".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("
"); } tab = "					"; Response.Write("Total: " + tab + dTotalPrice.ToString("N2")); // Response.Write(" Total: " + dTotalPrice.ToString("N2") + " "); dt.Dispose(); Response.End();

Midhun Tp · Answer

Hi, Can you please share your code for exporting data to excel?