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