public void SaveCSV(DataTable dt, string fullPath) { FileInfo fi = new FileInfo(fullPath);if (!fi.Directory.Exists) { fi.Directory.Create(); } FileStream fs = new FileStream(fullPath, System.IO.FileMode.Create, System.IO.FileAccess.Write);//StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.UTF8);string data = "";//写出列名称for (int i = 0; i < dt.Columns.Count; i++) { data += dt.Columns[i].ColumnName.ToString();if (i < dt.Columns.Count - 1) { data += ","; } } sw.WriteLine(data);//写出各行数据for (int i = 0; i < dt.Rows.Count; i++) { data = "";for (int j = 0; j < dt.Columns.Count; j++) {string str = dt.Rows[i][j].ToString(); str = str.Replace("\"", "\"\"");//替换英文冒号 英文冒号需要换成两个冒号if (str.Contains(',') || str.Contains('"') || str.Contains('\r') || str.Contains('\n')) //含逗号 冒号 换行符的需要放到引号中 { str = string.Format("\"{0}\"", str); } data += str;if (j < dt.Columns.Count - 1) { data += ","; } } sw.WriteLine(data); } sw.Close(); fs.Close(); }
下方是button的click事件
private void SaveBtn_Click(object sender, EventArgs e) {var pList = xmlHelp.XmlDeSerializer("User");//序列化获取list数据,可用其他方法创建表格,xmlHelp是一个类 DataTable dt = new DataTable(); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("性别", typeof(string)); dt.Columns.Add("年龄", typeof(string)); dt.Columns.Add("编号", typeof(string));foreach (var item in pList) { dt.Rows.Add(item.Name, item.Sex, item.Age, item.Id); } xmlHelp.SaveCSV(dt, "Use");//总之只要调用SaveCSV添加datatable和string格式的路径命名即可保存
}