下面是关于CSV操作的一些函数
public static void WriteCSV(string filePathName, List<String[]> ls)
{
WriteCSV(filePathName, false, ls);
}
public static void WriteCSV(string filePathName, bool append, List<String[]> ls)
{
StreamWriter fileWriter = new StreamWriter(filePathName, append, Encoding.UTF8);
foreach (String[] strArr in ls)
{
fileWriter.WriteLine(String.Join("/t", strArr));
}
fileWriter.Flush();
fileWriter.Close();
}
public static List<String[]> ReadCSV(string filePathName)
{
List<String[]> ls = new List<String[]>();
StreamReader fileReader = new StreamReader(filePathName);
string strLine = "";
while (strLine != null)
{
strLine = fileReader.ReadLine();
if (strLine != null && strLine.Length > 0)
{
ls.Add(strLine.Split('/t'));
}
}
fileReader.Close();
return ls;
}
public static void DeleteCsvLine(string filePathName, string temp)
{
StreamReader reader = new StreamReader(filePathName, Encoding.UTF8);
List<String[]> ls = new List<String[]>();
string strLine = "";
while (strLine != null)
{
strLine = reader.ReadLine();
if (strLine != null && strLine.Length > 0)
{
if (strLine != temp)
{
ls.Add(strLine.Split('/t'));
}
}
}
reader.Close();
WriteCSV(filePathName, false, ls);
}