Listbox

Question

LisBbox items values download to Excel Sheet in asp.net c#

Ashok Yadav · Answer

protected void btnExportfromDt_Click(object sender, EventArgs e) { DataTable dtplants = new DataTable(); dtplants.Columns.Add("Plants"); foreach (ListItem li in lbxPlants.Items) { DataRow drplants = dtplants.NewRow(); drplants[0] = li.Value; dtplants.Rows.Add(drplants); } string strFilename = "EmpDetails.xls"; UploadDataTableToExcel( dtplants , strFilename); } protected void UploadDataTableToExcel(DataTable dtEmp,string filename) { string attachment = "attachment; filename="+filename; Response.ClearContent(); Response.AddHeader("content-disposition", attachment); Response.ContentType = "application/vnd.ms-excel"; string tab = string.Empty; foreach (DataColumn dtcol in dtEmp.Columns) { Response.Write(tab + dtcol.ColumnName); tab = "	"; } Response.Write("
"); foreach (DataRow dr in dtEmp.Rows) { tab = ""; for (int j = 0; j { Response.Write(tab + Convert.ToString(dr[j])); tab = "	"; } Response.Write("
"); } Response.End(); }

Listbox

Answers (1)