当前位置： 移动技术网 > IT编程>开发语言>.net > C#保存数据为CSV文件、Excel文档

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

2018年03月01日  | 移动技术网IT编程  | 我要评论

金复新,湖北人事局,说说心情

 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                 else
35                 {
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         }
View Code

 

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网