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

2018-03-01 07:48:27来源:cnblogs.com作者:BaoMingZhu人点击

分享
 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         }

最新文章

123

最新摄影

闪念基因

微信扫一扫

第七城市微信公众平台