Question

Hi I was wondering using C# how I would view a .CSV file, add a new row then save the file?

Answer 1

Input csv file format

doc - Microsoft Excel Home Insert Page Layout Formulas Data Review View Team ぬCut a copy Calibri General Format Painter Merge & Center ▼ ▼ % , 11:08:21 Con Clipboard Font Alignment Number 18 1) 4 4

Output displaying the contents in the csv file

file:///c:/users/pranesh/documents/visual studio 2013/Projects/csvreaderfile/csv 4

output after adding the row in the csv file

5 4 0 1 2 2 1234

code will be

using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;

namespace csvreaderfile
{
class Program
{
static void Main(string[] args)
{
//Reading the csv file and storing it in an array
string[] arr = File.ReadAllText("..//doc.csv").Split(',');
  
for(int i=0;i<arr.Length;i++)
{
Console.WriteLine(arr[i]);
}

Console.ReadLine();
//string content to write it to the next row
string val = "7,8,9,10,11,12";

  
File.AppendAllText("..//doc.csv", val);

  
}
}
}

Please rate it, if you have any doubts please comment it.