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

来源：互联网发布：pyqt5 for windows 编辑：程序博客网时间：2024/04/30 14:17
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表格            }        }    }}
0 0