C#导出Excel cvs数据

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.IO;

 

namespace TopAPI
{
    class ExcelCreate
        {

        public void CreateCsv(System.Data.DataTable dt, string strName)
         {
            
        
           
            //先打印标头
            StringBuilder strColu=new StringBuilder();
            StringBuilder strValue=new StringBuilder();
            int i=0;
   
            try
            {
                StreamWriter sw = new StreamWriter(new FileStream(strName+".csv", FileMode.Create), Encoding.GetEncoding("GB2312"));

                for( i=0;i<=dt.Columns.Count-1;i++)
                {
                    strColu.Append("/""+dt.Columns[i].ColumnName+"/"");
                    strColu.Append(",");                }
                    strColu.Remove(strColu.Length-1,1);//移出掉最后一个,字符

                    sw.WriteLine(strColu);

                foreach(DataRow dr in dt.Rows)
                {
                    strValue.Remove(0,strValue.Length);//移出
       
                    for(i=0;i<=dt.Columns.Count-1;i++)                    {
                        strValue.Append("/""+dr[i].ToString().Replace("'","''").Replace (",","，")+"/"");
                        strValue.Append(",");
                    }
                        strValue.Remove(strValue.Length-1,1);//移出掉最后一个,字符
                        sw.WriteLine(strValue);
                }
               
                sw.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);

            }

         
               
        }

        public   void CreateExcel(DataTable source, string fileName)
        {

            System.IO.StreamWriter excelDoc;
            excelDoc = new System.IO.StreamWriter(fileName);
            const string startExcelXM