C#中将dataGridView导到excel

来源：互联网发布：禁止在淘宝网上出售编辑：程序博客网时间：2024/05/26 19:16

工程中-右击引用-添加-COM-选择microsoft excel
1.先去导入dll库：Microsoft.Office.Interop.Excel.dl

这里写图片描述

2.然后再去写代码：

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;    }}

电脑装OFFICE2007的话，
这里写图片描述

阅读全文

0 0