winform中 将DataGrid中的数据导入Excel中,并显示Excel应用程序

        /// <summary>         /// 将DataGrid中的数据导入Excel中,并显示Excel应用程序，          /// 注意调用该方法必须有安装Excel 2000应用程序,并且假定DataGrid中绑定的是一DataSet          /// </summary>          /// <param name="grid"></param>          /// <param name="ReportTitle"></param>          public  static  void ExportDataGridToExcel (DataGrid grid , string ReportTitle )          {             DataTable myTable  =  ( (DataSet )grid .DataSource ) .Tables [0 ] ;              try              {                 Excel .Application xlApp  =  new Excel .ApplicationClass ( ) ;                  int rowIndex ;                  int colIndex ;                 rowIndex  = 2 ;                 colIndex  = 0 ;                 Excel .Workbook xlBook  =xlApp .Workbooks .Add ( true ) ;                                 if  (grid .TableStyles .Count  >0  )                   {                     Excel .Range range  = xlApp .get_Range (xlApp .Cells [1 ,1 ] ,xlApp .Cells [1 ,grid .TableStyles [0 ] .GridColumnStyles .Count ] ) ;                     range .MergeCells  =  true ;                     xlApp .ActiveCell .FormulaR1C1   = ReportTitle ;                     xlApp .ActiveCell .Font .Size   = 18 ;                     xlApp .ActiveCell .Font .Bold  =  true ;                       foreach (DataGridColumnStyle colu  in grid .TableStyles [0 ] .GridColumnStyles )                      {                         colIndex =colIndex  +1 ;                         xlApp .Cells [2 ,colIndex ]  = colu .HeaderText  ;                      }                      //得到的表所有行,赋值给单元格                      for  ( int row  = 0 ;row  < myTable .Rows .Count ;row + + )                      {                         rowIndex  = rowIndex  + 1 ;                         colIndex  = 0 ;                          for  ( int col =0 ;col <grid .TableStyles [0 ] .GridColumnStyles .Count ;col + + )                          {                             colIndex  = colIndex  + 1 ;                             xlApp .Cells [rowIndex , colIndex ]  = grid [row ,col ] .ToString ( ) ;                          }                                          }                  }                  else                  {                      Excel .Range range  = xlApp .get_Range (xlApp .Cells [1 ,1 ] ,xlApp .Cells [1 ,myTable .Columns .Count ] ) ;                     range .MergeCells  =  true ;                     xlApp .ActiveCell .FormulaR1C1   = ReportTitle ;                     xlApp .ActiveCell .Font .Size   = 18 ;                     xlApp .ActiveCell .Font .Bold  =  true ;                                           //将表中的栏位名称填到Excel的第一行                      foreach (DataColumn Col  in myTable .Columns )                      {                         colIndex  = colIndex  + 1 ;                         xlApp .Cells [2 , colIndex ]  = Col .ColumnName ;                                      }                      //得到的表所有行,赋值给单元格                      for  ( int row  = 0 ;row  < myTable .Rows .Count ;row + + )                      {                         rowIndex  = rowIndex  + 1 ;                         colIndex  = 0 ;                          for  ( int col =0 ;col <myTable .Columns .Count ;col + + )                          {                             colIndex  = colIndex  + 1 ;                             xlApp .Cells [rowIndex , colIndex ]  = grid [row ,col ] .ToString ( ) ;                          }                                          }                  }                               xlApp .get_Range (xlApp .Cells [2 , 1 ] , xlApp .Cells [2 , colIndex ] ) .Font .Bold  =  true ;                 xlApp .get_Range (xlApp .Cells [2 , 1 ] , xlApp .Cells [rowIndex , colIndex ] ) .Borders .LineStyle  = 1 ;                           xlApp .Cells .EntireColumn .AutoFit ( ) ;                 xlApp .Cells .VerticalAlignment  = Excel .Constants .xlCenter  ;                 xlApp .Cells .HorizontalAlignment  = Excel .Constants .xlCenter  ;                         xlApp .Visible  =  true ;                          }              catch (Exception e )              {                  throw e ;              }                       }