DataGridView 导出Excel （封装）

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Windows.Forms;namespace DataGridView_Excel{    /// <summary>    /// 先添加引用 Microsoft.Office.Interop.Excel（在.Net）    /// </summary>    public class DGVExcel    {        /// <summary>        /// 将多个DataGridView 导入到一个Excel里        /// </summary>        /// <param name="dgvlist"></param>        public void ALLdgvExportDataExcel(List<DataGridView> dgvlist)        {            )            {                string fileName = "";                string saveFileName = "";                SaveFileDialog saveDialog = new SaveFileDialog();                saveDialog.DefaultExt = "xls";                saveDialog.Filter = "Excel文件|*.xls";                saveDialog.FileName = fileName;                saveDialog.ShowDialog();                saveFileName = saveDialog.FileName;                )                {                    //被点了取消                    return;                }                Microsoft.Office.Interop.Excel.Application xlapp = new Microsoft.Office.Interop.Excel.Application();                if (xlapp == null)                {                    MessageBox.Show("无法创建Excel对象，您的电脑可能未安装Excel");                    return;                }                Microsoft.Office.Interop.Excel.Workbooks workbooks = xlapp.Workbooks;                Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);                ; i < dgvlist.Count; i++)                {                    //取得sheet                    Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[];                    worksheet.Name = dgvlist[i].Name;                    //worksheet写入标题                    ; j < dgvlist[j].ColumnCount; j++)                    {                        worksheet.Cells[, j + ] = dgvlist[i].Columns[j].HeaderText;                    }                    //worksheet写入数值                    ; r < dgvlist[i].Rows.Count; r++)                    {                        ; k < dgvlist[i].ColumnCount; k++)                        {                            worksheet.Cells[r + , k + ] = dgvlist[k].Rows[r].Cells[k].Value;                        }                        System.Windows.Forms.Application.DoEvents();                    }                    //列宽自适应                    worksheet.Columns.EntireColumn.AutoFit();                }                MessageBox.Show(fileName + "保存成功！", "提示", MessageBoxButtons.OK);                if (saveFileName != "")                {                    try                    {                        workbook.Saved = true;                        workbook.SaveCopyAs(saveFileName);  //fileSaved = true;                    }                    catch (Exception ex)                    {                        //fileSaved = false;                        MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);                    }                }                xlapp.Quit();                //强行销毁（强制回收）                GC.Collect();            }        }        /// <summary>        /// 将一个DataGridView导入Excel        /// </summary>        /// <param name="dgv"></param>        public void OnedgvExportDataExcel(DataGridView dgv)        {            string fileName = "";            string saveFileName = "";            SaveFileDialog saveDialog = new SaveFileDialog();            saveDialog.DefaultExt = "xls";            saveDialog.Filter = "Excel文件|*.xls";            saveDialog.FileName = fileName;            saveDialog.ShowDialog();            saveFileName = saveDialog.FileName;            )            {                //被点了取消                return;            }            Microsoft.Office.Interop.Excel.Application xlapp = new Microsoft.Office.Interop.Excel.Application();            if (xlapp == null)            {                MessageBox.Show("无法创建Excel对象，您的电脑可能未安装Excel");                return;            }            Microsoft.Office.Interop.Excel.Workbooks workbooks = xlapp.Workbooks;            Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);            //取得sheet1            Microsoft.Office.Interop.Excel.Worksheet worksheet1 = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[];            worksheet1.Name = dgv.Name;            //worksheet1写入标题            ; i < dgv.ColumnCount; i++)            {                worksheet1.Cells[, i + ] = dgv.Columns[i].HeaderText;            }            //worksheet1写入数值            ; r < dgv.Rows.Count; r++)            {                ; i < dgv.ColumnCount; i++)                {                    worksheet1.Cells[r + , i + ] = dgv.Rows[r].Cells[i].Value;                }                System.Windows.Forms.Application.DoEvents();            }            //列宽自适应            worksheet1.Columns.EntireColumn.AutoFit();            MessageBox.Show(fileName + "保存成功！", "提示", MessageBoxButtons.OK);            if (saveFileName != "")            {                try                {                    workbook.Saved = true;                    workbook.SaveCopyAs(saveFileName);  //fileSaved = true;                }                catch (Exception ex)                {                    //fileSaved = false;                    MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);                }            }            xlapp.Quit();            //强行销毁（强制回收）            GC.Collect();        }    }}