/// <summary>
         /// 以操作Excel控件的方式将DataGridView数据导出到Excel add by sunny 2007/1/18
         /// </summary>
         /// <param name="GridView">DataGridView对象</param>
         /// <param name="strExcelFile">Excel文件名</param>
         /// <param name="strError">out参数，返回出错信息</param>
         /// <returns>
         ///     -1 出错
         ///     0 成功
         /// </returns>
         public static int DataGridViewToExcel(System.Windows.Forms.DataGridView GridView,
             string strExcelFileName,
             out string strError)
         {
             strError = "";
             int nRet = 0;

             Excel.Application xlApp = new Excel.Application();
             Excel.Workbooks workbooks = xlApp.Workbooks;
             Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
             Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];//取得sheet1

             try
             {
                 //~~
                 // 写字段名
                 for (int i = 0; i < GridView.Columns.Count; i++)
                 {
                     worksheet.Cells[1, i + 1] = GridView.Columns[i].HeaderText.ToString();
                 }

                 // 写记录
                 for (int i = 0; i < GridView.Rows.Count; i++)
                 {
                     for (int j = 0; j < GridView.Columns.Count; j++)
                     {
                         worksheet.Cells[i + 2, j + 1] = GridView.Rows[i].Cells[j].Value.ToString(); ;
                     }
                 }

                 worksheet.Columns.EntireColumn.AutoFit();//自动适应每列的宽度 add by sunny.li
                 Excel.Range rg = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, GridView.Columns.Count]);
                 rg.Font.Bold = true;
                 workbook.Saved = true;
                 workbook.SaveCopyAs(strExcelFileName);
               
                 // 关掉内存中的进程
                 xlApp.Quit();
                 nRet = 0;
             }
             catch (Exception ex)
             {
                 strError = ex.ToString();
                 nRet = -1;
             }

             return nRet;
         }