C#保存数据为CSV文件、Excel文档

来源:转载

 1 public void WriteData() 2 { 3 try 4 { 5 if (System.IO.Directory.Exists(DataFileRootPath) == false) 6 { 7 System.IO.Directory.CreateDirectory(DataFileRootPath); 8 } 9 StringBuilder DataColumn = new StringBuilder();10 StringBuilder DataLine = new StringBuilder();11 12 string strT = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "_" + DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "-" + DateTime.Now.Second.ToString() + "-" + DateTime.Now.Millisecond.ToString();13 14 //列标题15 DataColumn.Append("DateTime,");16 //行数据17 DataLine.Append(strT + ",");18 19 20 21 22 string FileName = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();23 string FilePath = DataFileRootPath + "//" + FileName + ".CSV";24 25 if (System.IO.File.Exists(FilePath) == false)26 {27 System.IO.StreamWriter stream = new System.IO.StreamWriter(FilePath, false, Encoding.UTF8);28 stream.WriteLine(DataColumn);29 stream.WriteLine(DataLine);30 stream.Flush();31 stream.Close();32 stream.Dispose();33 }34 else35 {36 System.IO.StreamWriter stream = new System.IO.StreamWriter(FilePath, true, Encoding.UTF8);37 stream.WriteLine(DataLine);38 stream.Flush();39 stream.Close();40 stream.Dispose();41 }42 }43 catch (Exception ex)44 {45 46 }47 }

分享给朋友:
您可能感兴趣的文章:
随机阅读: