How can i export listbox items to csv using asp.net?

Question

protected void Button2_Click1(object sender, EventArgs e)
        {
        StreamWriter myOutputStream = new StreamWriter("Myfile.csv");

        foreach (var item in urlLst.Items)
        {
            myOutputStream.WriteLine(item.ToString());
        }

        myOutputStream.Close();
    }

I am using this code but not getting output.

Have you tried specifying an absolute path? Also please provide more info on "not getting output" - any exception thrown? — vasek
– vasek, Commented Dec 13, 2017 at 8:47

Arunbalaji.Selvaraj · Accepted Answer · 2017-12-13 09:00:03Z

1

Hi You can try the below code sample.

            int items = 10; //ListBoxItems.Items.Count;
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < items; i++)
            {

                sb.AppendLine(i.ToString()); //Loop through and get list box item values
            }

            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=ListBox_Contents.csv");
            Response.Charset = "";
            Response.ContentType = "application/vnd.csv";
            StringWriter stringWrite = new StringWriter(sb);
            HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
            Response.Write(stringWrite.ToString());
            Response.End();

answered Dec 13, 2017 at 9:00

Arunbalaji.Selvaraj

263 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arunbalaji.Selvaraj Over a year ago

Can you please tell me in which code you are getting empty CSV generated?

Arunbalaji.Selvaraj Over a year ago

Also, from your code you have to provide a directory path here. StreamWriter myOutputStream = new StreamWriter("Directory Path");

user8924688 Over a year ago

Thanks i have tried your code, it is proper. Now i am not getting empty csv.

Collectives™ on Stack Overflow

How can i export listbox items to csv using asp.net?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related