基本信息

---

下载

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

---

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

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

NPOI导出50000条数据约 3秒钟，office导出 就慢的不能忍受了。。。 

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 ExcelExportNpoi
{
    public partial class Mytest : Form
    {
        DataTable dt;
        public Mytest()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Bind();
          
           // ExcelHelper.DataTableToExcel(dt, "D:/Ab.xls");

        }      
        void Bind()
        {
            dt = new DataTable();
            DataColumn dc = new DataColumn("a");
            dt.Columns.Add(dc);
            dc = new DataColumn("b");
            dt.Columns.Add(dc);
            dc = new DataColumn("c");
            dt.Columns.Add(dc);
            for (int i = 0; i < 50000; i  )
            {

                DataRow dr = dt.NewRow();
                dr["a"] = i;
                dr["b"] = i 1000;
                dr["c"] = i   10000;
                dt.Rows.Add(dr);
            }
            //   data1.DataSource = dt;
            dataGridView1.DataSource = dt;
 
        }

        private void button1_Click(object sender, EventArgs e)
        {
            System.Diagnostics.Stopwatch timeWatch = System.Diagnostics.Stopwatch.StartNew();
           // ExcelHelper.DatagridviewToExcel(dataGridView1, "D:/AA.xlsx");
            
           
            //NPOIHelper.DataTableToExcel(dt, "测试", "D:/测试.xls");
            NPOIExcelHelper.DataGridViewToExcel(dataGridView1, "测试", "D:/mytest1.xls");
            timeWatch.Stop();
            MessageBox.Show("总共耗时" timeWatch.Elapsed);
           
        }

        private void button2_Click(object sender, EventArgs e)
        {
            System.Diagnostics.Stopwatch timeWatch = System.Diagnostics.Stopwatch.StartNew();
            ExportExcelHelper.ExportExcel("D:/mytest2.xls", dataGridView1, false);
            timeWatch.Stop();
            //Bind();
            MessageBox.Show("总共耗时"   timeWatch.Elapsed);
         
        }
    }
}