public static class CsvHelper
{
/// <summary>
/// 保存CSV文件
/// </summary>
/// <param name="WriteString">写入行字符串数组</param>
/// <param name="fileName">文件名称</param>
/// <param name="path">文件存放路径</param>
/// <param name="title">CSV文件 行标题</param>
public static void WriteCSVDate(string[] WriteString, string fileName, string path, string[] title, bool apend)
{
bool bfirst = false;
if (System.IO.Directory.Exists(path) == false)
{
System.IO.Directory.CreateDirectory(path);
}
string strFile = path + "\\" + fileName + ".csv";
if (System.IO.File.Exists(strFile) == false)
{
bfirst = true;
}
try
{
System.IO.StreamWriter swf = new System.IO.StreamWriter(strFile, apend, Encoding.Default);
if (bfirst)
{
string header = StringArrayInsertComma(title
);
swf.WriteLine(header);
}
string writeLine = StringArrayInsertComma(WriteString);
swf.WriteLine(writeLine);
swf.Close();
}
catch (System.Exception ex)
{
MessageBox.Show("csv文件操作出错:" + ex.Message,"错误");
WriteCSVDate(WriteString, fileName, path, title, apend); //重写CSV
}
}
//行字符串数组插入‘,’间隔
public static string StringArrayInsertComma(string[] line)
{
string result=string.Empty;
foreach (string item in line)
{
result =result+item + ',';
}
return result;
}
}