`
shenzhen_zsw
  • 浏览: 7210 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
最新评论

C#实现将DataGridView中的数据导入到Excel中

    博客分类:
  • C#
阅读更多
1.在开发环境的菜单中选择"项目"|"添加引用"选项

2.选择com选项卡,然后选择Microsoft Excel9.0Object Library组建名称,单击确定按钮添加成功!

3.详细代码如下:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
namespace excelform
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
       
        /// <summary>
        /// 将DataGridView控件中数据导出到Excel
        /// </summary>
        /// <param name="gridView">DataGridView对象</param>
        /// <param name="isShowExcle">是否显示Excel界面</param>
        /// <returns></returns>
        public bool ExportDataGridview(DataGridView gridView, bool isShowExcle)
        {
            if (gridView.Rows.Count == 0)
                return false;
            //建立Excel对象
            Excel.Application excel = new Excel.Application();
            excel.Application.Workbooks.Add(true);
            excel.Visible = isShowExcle;
            //生成字段名称
            for (int i = 0; i < gridView.ColumnCount; i++)
            {
                excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
            }
            //填充数据
            for (int i = 0; i < gridView.RowCount - 1; i++)         //循环行
            {
                
                for (int j = 0; j < gridView.ColumnCount; j++)      //循环列
                {                   
                    if (gridView[j, i].ValueType == typeof(string)) //判断DataGirdView中数据的类型
                    {
                        excel.Cells[i + 2, j + 1] = "'" + gridView[j, i].Value.ToString();
                    }
                    else
                    {
                        excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
                    }
                }
            }
            return true;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            this.ExportDataGridview(dataGridView1, true);
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Server=.;uid=sa;pwd=123;DataBase=accp;");
            SqlDataAdapter dap = new SqlDataAdapter("select * from userInfo", con);
            DataSet ds = new DataSet();
            dap.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
        }

    }
}
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics