DataGridView控件实现Excel表格导出

using System;
using System.Linq;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
// 添加引用 -> .NET -> Microsoft.Office.Interop.Excel(2003->11.0, 2007->12.0)

namespace ProductManager
{
    static class ClassExcel
    {
        /// <summary>
        /// 用 DataGridView 控件打印 Excel 表。
        /// </summary>
        /// <param name="dgv"></param>
        /// <param name="caption"></param>
        #region
        public static void PrintToExcel(this DataGridView dgv, string caption)
        {
            Excel.Application newExcel = new Excel.Application();
            try
            {
                Excel.Workbook newBook = newExcel.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
                Excel.Worksheet newSheet = newBook.ActiveSheet as Excel.Worksheet;
                newExcel.Visible = true;
                newBook.Password = "jinzhexian";
                newSheet.Name = caption;
                int column = dgv.ColumnCount;
                Excel.Range newRange = newSheet.get_Range("B2", Type.Missing).get_Resize(2, column);
                newRange.MergeCells = true; // 合并单元格。
                newRange.Font.Size = 16;