C#_把dataTable數據導出到CSV,XLS文件

//導出為svc文件
 2        public void ExportToSvc(System.Data.DataTable dt,string strName)
 3        {
 4             string strPath= Path.GetTempPath()+strName+".csv";
 5       
 6            if (File.Exists(strPath))
 7            {
 8                File.Delete(strPath);
 9            }
10            //先打印標頭
11            StringBuilder strColu=new StringBuilder();
12            StringBuilder strValue=new StringBuilder();
13            int i=0;
14   
15            try
16            {
17                StreamWriter sw = new StreamWriter(new FileStream(strPath, FileMode.CreateNew), Encoding.GetEncoding("GB2312"));
18
19                for( i=0;i<=dt.Columns.Count-1;i++)
20                {
21                    strColu.Append(dt.Columns[i].ColumnName);
22                    strColu.Append(",");
23                }
24                strColu.Remove(strColu.Length-1,1);//移出掉最後一個,字符
25
26                sw.WriteLine(strColu);
27
28                foreach(DataRow dr in dt.Rows)
29                {
30                    strValue.Remove(0,strValue.Length);//移出
31       
32                    for(i=0;i<=dt.Columns.Count-1;i++)
33                    {
34                        strValue.Append(dr[i].ToString());
35                        strValue.Append(",");
36                    }
37                    strValue.Remove(strValue.Length-1,1);//移出掉最後一個,字符
38                    sw.WriteLine(strValue);
39                }
40               
41                sw.Close();
42            }
43            catch(Exception ex)
44            {
45                MessageBox.Show(ex.Message);
46
47            }
48
49            System.Diagnostics.Process.Start(strPath);
50               
51        }

//*******
作者:        wesimy
時間:        07/31/05
版本:        v.2.1
函數名:     DatatableToCSVFile
參數說明:   DataTable dt 導出CSV的數據
                string xbkPahth    CSV模板,主要存儲一些表頭的格式
                string SavePath    導出的路徑
                ref string err        出錯提示
功能:         把DataTable的數據導出到CSV文件中
 
********//
 
public void DatatableToCSVFile(System.Data.DataTable dt, string xbkPath, string SavePath, ref string err)
  {
   string row;
   try
   {
    string header;
    string tmp;
    StreamReader sr=new StreamReader(xbkPath);
    header=sr.ReadLine();
   
    sr.Close();
    FileStream fs=File.Create(SavePath);
    StreamWriter sw= new StreamWriter (fs);
    sw.WriteLine(header);
   
    foreach(DataRow dr in dt.Rows)
    {
     row="";
     for(int i=0;i<dt.Columns.Count;i++)
     {
      if(i!=dt.Columns.Count-1)
      {
       tmp= dr[i].ToString().Trim().Replace(","," ");
       row=row+tmp+",";
      }
      else
      {
       tmp= dr[i].ToString().Trim().Replace(",",".");
       row=row+tmp;
      }
     }
     sw.WriteLine(row);
    }
    sw.Flush();
    sw.Close();
   }
   catch(Exception ex)
   {