C#将dataGridView中显示的数据导出到Excel(超实用版)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop;
using Microsoft.Office.Interop.Excel;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel; 

public class ExprotToExcel
{ 
    public void  DataToExcel(DataGridView dgv,ToolStripProgressBar tempProgressBar,ToolStripStatusLabel toolstrip)
    {
        if (dgv.Rows.Count == 0)
        {
            MessageBox.Show("无数据"); return;
        }
        MessageBox.Show("开始生成要导出的数据", "导出提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        Excel.Application excel = new Excel.Application();
        excel.Application.Workbooks.Add(true);
        excel.Visible = false;   
        for (int i = 0; i < dgv.ColumnCount; i++)
            excel.Cells[1, i + 1] = dgv.Columns[i].HeaderText;
        tempProgressBar.Visible = true;
        tempProgressBar.Minimum = 1;
        tempProgressBar.Maximum = dgv.RowCount;
        tempProgressBar.Step = 1;
        toolstrip.Visible = true;
        for (int i = 0; i < dgv.RowCount; i++)
        {
            for (int j = 0; j < dgv.ColumnCount; j++)
            {
                if (dgv[j, i].ValueType == typeof(string))
                {
                    excel.Cells[i + 2, j + 1] = "'" + dgv[j, i].Value.ToString();
                }
                else
                {
                    excel.Cells[i + 2, j + 1] = dgv[j, i].Value.ToString();
                }
            }
            toolstrip.Text = "|| 状态:正在生成第 "+i+"/"+dgv.RowCount+" 个";
            tempProgressBar.Value = i + 1;
        }
        toolstrip.Text = "|| 状态:生成成功!";
        MessageBox.Show("生成成功,请保存。","生成提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
        excel.Visible = true;
    }
}

C#将dataGridView中显示的数据导出到Excel(超实用版)

上一篇:Elasticsearch IK分词器


下一篇:在win下,如何用bat看程序运行的时间