Export listbox values to excel using VB.NET

Question

1.00/5 (1 vote)

See more:

Hello All,

I need an code that will help me to export values from three listbox to excel or text file by using save file dialog.
Thanks

What I have tried:

Dim w as io.streamwriter
Dim I as integer
W = new iO.streamwriter ("c:\" & ".text")
For I = 0 to listbox1.items.count -1
W.writeline(listbox1.items.item(i))
Next
W.close()

Posted 12-Mar-22 10:17am

Elias Ar

Updated 13-Mar-22 3:13am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2022-03-12T11:40:00

Solution 1

Your filename is C:\.text. That's not legal in windows.

Why is it people do this:

"C:\" & ".text"

and not just skip the concatenation entirely since it's not needed:

"C:\filename.txt"

Posted 12-Mar-22 11:40am

Dave Kreskowiak

Comments

Elias Ar 13-Mar-22 1:34am

Bro,
Your reply doesn't help me, I know I should put the file name but I'm asking for something else, How I can save an Excel or Text file by using the save file dialog, please read the post three times before replying.
Thanks

Maciej Los · Answer 2 · 2022-03-13T03:13:00

Take a look at MSDN documentation:
SaveFileDialog Class (System.Windows.Forms) | Microsoft Docs[^]
How to: Write Text to Files with a StreamWriter - Visual Basic | Microsoft Docs[^]

If you would like to write data into Excel file, i'd suggest to install EPPlus 4.5.3.3 NuGet package[^]. Here is CP article with example code: How to Use EPPlus in VB[^]