Save items from ListBox to excel file

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 < number; 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

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