Save items from ListBox to excel file

Question

How to save value from listBox to existing Excel file?

Sam Hobbs · Answer

Also look at the articles in this web site about Excel.

clark · Answer

Here is code to display the items of a listbox in a csv file, which will be automatically launched in Excel. It is designed to be used in asp.net. int number = ListBox1.Items.Count; StringBuilder sw = new StringBuilder (); for ( int i = 0; i { sw.AppendLine(ListBox1.Items[i].ToString()); } Response.Clear(); Response.AddHeader( "content-disposition" , "attachment;filename=Collection_Contents.csv" ); Response.Charset = "" ; Response.ContentType = "application/vnd.csv" ; StringWriter stringWrite = new StringWriter (sw); HtmlTextWriter htmlWrite = new HtmlTextWriter (stringWrite); Response.Write(stringWrite.ToString()); Response.End(); Clark Bohs

Lalit M · Answer

you can also export listbox value to excel show here code sampel Dim MsExcel As Excel .Application Private Sub Command1_Click() MsExcel.Workbooks.Add MsExcel.Range("A1").Value = List1.List(0) MsExcel.Range("B1").Value = List1.List(1) MsExcel.Range("C1").Value = List1.List(2) MsExcel.Visible = True End Sub Private Sub Command2_Click() With List1 .AddItem (txtName.Text) .AddItem (txtEmail.Text) .AddItem (txtMobile.Text) End With End Sub Private Sub Form_Load() Set MsExcel = CreateObject(" Excel .Application") End Sub

Save items from ListBox to excel file

Answers (3)