C# 将查询的结果导出到EXCEL

 

                  // 开始文件名
                  string  fname2  =   " d:/ " ;
                  string  fname1  =   " square_ "   +  DateTime.Now.Month.ToString()  +  DateTime.Now.Day.ToString()  +  DateTime.Now.Hour.ToString()  +  DateTime.Now.Minute.ToString()  +  DateTime.Now.Second.ToString();
                 string  FileName  =  fname2 + fname1 + " .xls " ;

                System.Data.DataTable dt  =   new  System.Data.DataTable();
                 // 将数据库查询的结果返回给DT
                          ... ...
                 //
                FileStream objFileStream;
                StreamWriter objStreamWriter;
                 string  strLine  =   "" ;
                objFileStream  =   new  FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write);
                objStreamWriter  =   new  StreamWriter(objFileStream, System.Text.Encoding.Unicode);

                // 插入标题
                 for  ( int  i  =   0 ; i  <  dt.Columns.Count; i ++ )
                ... {
                  strLine = strLine + dt.Columns[i].ColumnName.ToString() + Convert.ToChar(9);
                }
                   objStreamWriter.WriteLine(strLine);
                strLine  =   "" ;

                // 开始插入数据
                 for  ( int  i  =   0 ; i  <  dt.Rows.Count; i ++ )
                 ... {
                    strLine = strLine + (i + 1) + Convert.ToChar(9);
                    for (int j = 1; j < dt.Columns.Count; j++)
                    ...{
                        strLine = strLine + dt.Rows[i][j].ToString() + Convert.ToChar(9);
                    }
                    objStreamWriter.WriteLine(strLine);
                    strLine = "";
                }
                objStreamWriter.Close();
                objFileStream.Close();