C# print multiple columns in different cells in EXCEL

Question

I am working on C# in Win 7.

I need to print to a .txt file by Streamwriter.

  StreamWriter outputfile              = new StreamWriter(MYPATH, true);
  outputfile.Write(String.Format(WIDTH_1 + Constants.WIDTH_1, item1 + " " + subitem + "(ave.)" , item2 + " "+ subitem + "(dev.)"));

Here, WIDTH_1 is "{0,30}", WIDTH_2 is "{1,30}". item2 and item1 are all strings. subitme is string.

When I open it in EXCEL 2012, all columns are in one cell.

I need to print each column in a distinct cell.

Any help would be appreciated.

Thanks

Try adding a tab character (\t) between each column value. – Wagner DosAnjos Feb 12 '14 at 00:32 — Wagner DosAnjos, Feb 12 '14 at 00:32
@wdosanjos , no it does not work. Thanks ! – user2420472 Feb 12 '14 at 00:36 — user2420472, Feb 12 '14 at 00:36

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

1.Make sure the file you are outputting to is in CSV format (*.CSV)

2.Make sure you have commas between the different columns as follows:

outputfile.Write(String.Concat(col1value, ",", col2value, ",", col3value));

3.Consider using a specific CSV library, rather than rolling your own. Follow the advice 'don't roll your own'.

Are there any CSV readers/writer libraries in C#?

edited May 23 '17 at 10:25

Community

1
1

answered Feb 12 '14 at 01:09

Jon Barker

1,788
15
25

the output file is .txt not .csv. Is this a problem ? – user2420472 Feb 12 '14 at 04:15

C# print multiple columns in different cells in EXCEL

1 Answers1