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]BeneficiaryBranchNameBeneficiaryName[BeneficiaryAccount No]BeneficiaryIFSCAmount from vwneft where PaymentDate between ' + general.getdate(txtFromdate.Text) +  ' and '  + general.getdate(txtEndDate.Text) +   +  + 23:59:00 +  '); } else { dt = gen.getDataTable(select [BeneficiaryBank Name]BeneficiaryBranchNameBeneficiaryName[BeneficiaryAccount No]BeneficiaryIFSCAmount from vwneft); } // DataTable dt = gen.getDataTable(select [BeneficiaryBank Name]BeneficiaryBranchNameBeneficiaryName[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 T P · Answer

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