要利用datagridview实现把SQL的查询结果导出Excel.cs

    private SQLHelper sqlhelper;
        public 要利用datagridview实现导出Excel()
        {


            InitializeComponent();
            sqlhelper = new SQLHelper();
        }

        public DataTable data()
        {
            string sql = "select * from sheet1";

            DataTable dt = sqlhelper.ExecuteQuery(sql, CommandType.Text);
            return dt;

        }
        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dt = data();
            dataGridView1.DataSource = dt;
            if (dataGridView1.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 < dataGridView1.ColumnCount; i++)
            {
                excel.Cells[1, i + 1] = dataGridView1.Columns[i].HeaderText;//将数据表格控件中的列表头填充到Excel中
            }
            //填充数据
            for (int i = 0; i < dataGridView1.RowCount - 1; i++)//遍历数据表格控件的所有行
            {
                for (int j = 0; j < dataGridView1.ColumnCount; j++)//遍历数据表格控件的所有列
                {
                    if (dataGridView1[j, i].ValueType == typeof(string))//判断遍历到的数据是否是字符串类型
                    {
                        excel.Cells[i + 2, j + 1] = "'" + dataGridView1[j, i].Value.ToString();//填充Excel表格
                    }
                    else
                    {
                        excel.Cells[i + 2, j + 1] = dataGridView1[j, i].Value.ToString();//填充Excel表格
                    }
                }
            }

        }