1.首先(NPOI官网下载dll)
添加引用:NPOI.dll,NPOI.OOXML.dll,NPOI.OpenXml4Net.dll,NPOI.OpenXmlFormats.dll
2.代码——CSVHelper
1 public class CSVHelper 2 { 3 /// <summary> 4 /// 写入CSV 5 /// </summary> 6 /// <param name="fileName">文件名</param> 7 /// <param name="dt">要写入的datatable</param> 8 public static void WriteCSV(string fileName,DataTable dt) 9 { 10 FileStream fs; 11 StreamWriter sw; 12 string data = null; 13 14 //判断文件是否存在,存在就不再次写入列名 15 if (!File.Exists(fileName)) 16 { 17 fs = new FileStream(fileName, FileMode.Create, FileAccess.Write); 18 sw =