gridview导出excel

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 ExprotToExc

el{ 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…… 全文阅读：C#将dataGridView中显示的数据导出到Excel（超实用版）把gridview导出excel收藏起来以后再看！gridview导出excel所属栏目：〖excel〗