CSV file double-spacing lines

Question

I am having trouble with OpenOffice Calc opening a CSV file that I create using StreamWriter C#. When it opens it has empty lines between every line that should be there(double-spaced). There seems to be some kind of doubling of the carriage returns. When I open it in Notepad it reads correctly. When I changed the program to write integers instead of strings the problem went away. It seems to be adding a return on the end of each string and then the formating adds another return that I'm not seeing.

Output looks like this...

1...

2...

3...

Output should look like this...

1...
2...
3...

Here is the ForEach loop I use to write the List to file...

using (StreamWriter sw = new StreamWriter(@"c:\andy\Arduino StreamWriter.csv", false, Encoding.UTF8))
        {
            foreach (string element in SerialPortString)
            {
                sw.WriteLine(element);
            }
        }

There is only one field of data per line, so there are no delimiters, just new lines. I tried formatting so that it would write with quotes around each field hoping that would eliminate confusion for the CSV format, but I wasn't able to figure that out either.

Any help would be appreciated.

Thanks.

Answer 1

Change

sw.WriteLine(element);

to

sw.WriteLine(element.Trim());

or maybe

sw.WriteLine(element.TrimEnd());

Trim the element first. That will remove any LineFeeds or other whitespace characters around the 'edges' of the characters. Then the StreamWriter's CRLFs will be the only newlines present.