Writing to CSV File

Question

Guys

Can anyone point me to any samples that will show me how to write to a CSV File.

There are some example here but all in C#

My App is in Visual Basic and Im using Windows 8.1 VS 2013

I have 6 textboxs on my page each with some text in. I need to save them when i click a button as one line in a CSV file appended to whatever is already in the file

The idea is I can then load the CSV into excel and use the data to poulate a form and send email

Any Ideas where I start

Mark

Answer 1

guys

I have the following code to get the contents of the 6 text boxes into a variable

        Dim dave
        dave = tb1.Text & "," & tb2.Text & "," & tb3.Text  & "," & tb4.Text & "," &  tb5.Text & "," & tb6.Text

what i Need to do is append the variable "dave" to the CSV file "C:\data.csv"

Mark

Answer 2

Guys

I have worked out the following

    Private Async Sub savebutton_Click(sender As Object, e As RoutedEventArgs) Handles savebutton.Click
        Dim dave
        dave = pageTitle.Text & "," &  comboBox1.SelectedItem.ToString & "," & comboBox2.SelectedItem.ToString & "," & room.Text & "," & fault.Text & "," & comboBox3.SelectedItem.ToString & "," & phototextbox.Text
        Dim storageFolder As StorageFolder = KnownFolders.DocumentsLibrary
        Dim sampleFile As StorageFile = Await storageFolder.CreateFileAsync("sample.csv")
        Await Windows.Storage.FileIO.AppendTextAsync(sampleFile, dave.ToString)
    End Sub

This works perfectly as long as there is no file called "sample.csv"

I need to sort 3 things

1. Check if the file exists

2. Change the storage folder as the defaultDocuments folder is on my sky drive and not in Users folder

3. Instead of creating a new file I need to append to an existing file

I think I can appending using

FileIO.AppendTextAsync(storageFolder , String)

But I can't workout how to specify the storageFolder element

Any Ideas

Mark

Answer 3

Ok Managed to sort the append

 Await Windows.Storage.FileIO.AppendTextAsync(sampleFile, dave.ToString)

This does append to the file but on the same line

How do I send a LfCr so that the second text is on the next line of the file

Mark