导入CSV文件
public static DataTable ImportFromCsv(string filePath)//从csv读取数据返回table {//Encoding encoding = mon.GetType(filePath); //Encoding.ASCII;// DataTable dt = new DataTable();FileStream fs = new FileStream(filePath, System.IO.FileMode.Open, System.IO.FileAccess.Read);//StreamReader sr = new StreamReader(fs, Encoding.UTF8); StreamReader sr = new StreamReader(fs, Encoding.Default);//记录每次读取的一行记录 string strLine = "";//记录每行记录中的各字段内容 string[] aryLine = null;//标示列数 int columnCount = 0;//标示是否是读取的第一行 bool IsFirst = true;//逐行读取CSV中的数据 while ((strLine = sr.ReadLine()) != null){DataRow dr = dt.NewRow();aryLine = strLine.Split(',');if (IsFirst == true){IsFirst = false;columnCount = aryLine.Length;//创建列 for (int i = 0; i < columnCount; i++){DataColumn dc = new DataColumn(aryLine[i].ToString());dt.Columns.Add(dc);}}else{for (int j = 0; j < columnCount; j++){dr[j] = aryLine[j];}dt.Rows.Add(dr);}}sr.Close();fs.Close();return dt;}
导出CSV文件
public static string ExportToCsv(System.Data.DataTable dt, string path){string result = string.Empty;try{// 实例化流对象，以特定的编码向流中写入字符。 StreamWriter sw = new StreamWriter(path, false, Encoding.GetEncoding("gb2312"));StringBuilder sb = new StringBuilder();for (int k = 0; k < dt.Columns.Count; k++){// 添加列名称 sb.Append(dt.Columns[k].ColumnName.ToString());if (k < dt.Columns.Count - 1){sb.Append(",");}}sb.Append(Environment.NewLine);// 添加行数据 for (int i = 0; i < dt.Rows.Count; i++){DataRow row = dt.Rows[i];for (int j = 0; j < dt.Columns.Count; j++){// 根据列数追加行数据 sb.Append(row[j].ToString());if (j < dt.Columns.Count - 1){sb.Append(",");}}sb.Append(Environment.NewLine);}sw.Write(sb.ToString());sw.Flush();sw.Close();sw.Dispose();// 导出成功后打开 //System.Diagnostics.Process.Start(path); }
