How to Create a CVS File in VB.Net

Submitted by: 
Visitors have accessed this post 190 times.

Let’s learn how to create CSV file in Visual Basic 2015. CSV file is a Comma Separated Value that is a commonly used format in text editor such as Microsoft Excel, OpenOffice Calc, notepad and Google docs. It is a plain text file that contains a list of data record. Each of its data record consist one or more fields that are separated by commas. So, in this tutorial, I’m going to teach you how to read and write the CSV file in a simple way. Just follow the steps below to see how it works.

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application in visual basic.
ps1

Step 2

Add a Button into the form.
ps2

Step 3

Create a method to read and write a CSV file using StreamWriter and StreamReader.

  1. Public Sub WriteCSVfile()
  2. Try
  3. 'A TextReader is use to read character from a byte in a particular encoding
  4. Dim stReader As StreamReader = New System.IO.StreamReader(File.OpenRead("c:\CSV\Testing.csv"))
  5.  
  6. 'It initialize the instance of List(of String) class that has the default initial capacity
  7. Dim strList As New List(Of String)()
  8.  
  9. 'It validates whether the particular file is already exist
  10. If File.Exists("c:\CSV\TestingOut.csv") Then
  11. 'Deleting the file
  12. File.Delete("c:\CSV\TestingOut.csv")
  13. End If
  14.  
  15. 'For the specified file, you have to initialize a new instance of the StreamWriter class
  16. 'for encoding and buffering the size
  17. Dim stWriter As New StreamWriter("c:\CSV\TestingOut.csv")
  18. 'Declare an empty string variable
  19. Dim str As String = String.Empty
  20.  
  21. While stReader.Peek() >= 0
  22. Dim strline As String = stReader.ReadLine()
  23. Dim strvalues As String() = strline.Split(";"c)
  24. strList.Add(strvalues(0))
  25. str = str + strline + Chr(10)
  26. End While
  27.  
  28. 'It will close the StreamReader object and the underlying stream
  29. 'It releases any system resources associate the reader
  30. stReader.Close()
  31. 'It will write a string to the stream
  32. stWriter.Write(str)
  33. 'It will close the current object and the underlying stream
  34. stWriter.Close()
  35.  
  36. Catch ex As Exception
  37. 'Catching errors
  38. MessageBox.Show(ex.Message)
  39. End Try
  40.  
  41. End Sub

Step 4

Double click a button to fire the click event handler of it and do the following codes for reading and writing CSV file in the specified path when the button is clicked.

  1. Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
  2. WriteCSVfile()
  3. End Sub

For any questions about this article. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
Or feel free to comment below.


Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.