EXCEL：将SQL SERVER中的数据导入到 EXCEL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Word = Microsoft.Office.Interop.Word;
using System.Threading;
using office = Microsoft.Office.Core;
using System.Reflection;
using System.IO;
using System.Text.RegularExpressions;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string conStr = ConfigurationManager.ConnectionStrings["conStr"].ToString();
            using (SqlConnection con = new SqlConnection(conStr))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand("select * from tb_Employee", con);
                SqlDataReader sdr = cmd.ExecuteReader();
                GridView1.DataSource = sdr;
                GridView1.DataBind();
            }
        }
    }

    protected void btnExport_Click(object sender, EventArgs e)
    {
        if (GridView1.Rows.Count == 0)//判断是否有数据
            return;//返回
        Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();//实例化Excel对象
        excel.Application.Workbooks.Add(true);//在Excel中添加一个工作簿
        excel.Visible = true;//设置Excel显示
        //生成字段名称
        for (int i = 0; i < GridView1.Columns.Count; i++)
        {
            excel.Cells[1, i + 1] = GridView1.Columns[i].HeaderText;//将数据表格控件中的列表头填充到Excel中
        }
        //填充数据
        for (int i = 0; i < GridView1.Rows.Count; i++)//遍历数据表格控件的所有行
        {
            for (int j = 0; j < GridView1.Columns.Count; j++)//遍历数据表格控件的所有列
            {
                excel.Cells[i + 2, j + 1] = GridView1.Rows[i].Cells[j].Text;//填充Excel表格
            }
        }
    }
}