基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Excel
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            BindShow();
        }
        public void BindShow() 
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("no"));
            dt.Columns.Add(new DataColumn("name"));
            dt.Columns.Add(new DataColumn("age"));
            dt.Columns.Add(new DataColumn("sex"));
            DataRow dr = dt.NewRow();
            dr[0] = 1;
            dr[1] = "宋玉";
            dr[2] = 15;
            dr[3] = "女";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = 2;
            dr[1] = "宋玉2";
            dr[2] = 152;
            dr[3] = "女2";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = 3;
            dr[1] = "宋玉3";
            dr[2] = 153;
            dr[3] = "女3";
            dt.Rows.Add(dr);
            this.dataGridView1.DataSource = dt;

        
        }

        private void 保存ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Microsoft.Office.Interop.Excel.Application excel =
                new Microsoft.Office.Interop.Excel.Application();
            excel.SheetsInNewWorkbook = 1;
            excel.Workbooks.Add();
            Microsoft.Office.Interop.Excel.Worksheet ws =
                (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveWorkbook.Worksheets[1];
            ws.Name = "信息表";
            for (int i = 0; i < this.dataGridView1.Rows.Count; i  )
            {
                for (int j = 0; j < this.dataGridView1.Rows[i].Cells.Count; j  )
                {
                    ws.Cells[i 1, j 1] = this.dataGridView1.Rows[i].Cells[j].Value;
                }
            }


            excel.Visible = true;
        }
    }
}