Once again I have trawled the web for a WPF (VB) example of writing to a CSV file. I have found several in C# and Forms VB and managed to work out reading from CSV. However, the writing version I have come up with adds a blank line after each actual line.
Also the first cell written to the CSV file contains some wierd characters just before the genuine content. (i.e. #?!Name1 instead of just Name1); I have shown the code below.
If File.Exists("resources\csvData.csv") Then
MsgBox("resources\csvData.csv doesn't exist")
MyFileName = "resources\csvData.csv"
myCSVWriter = My.Computer.FileSystem.OpenTextFileWriter(MyFileName, True)
For y = 0 To 14
myNewLine = ""
View Complete Post