winform高效导出Excel带格式设置.docVIP

winform高效导出Excel带格式设置 //-***************获取要写入excel的数据源*************** 2 Dao model=new Dao(); 3 DataTable dt=model.GetFileNameList(0,intPageSize,Convert.ToDateTime(dtPFrom.Value), Convert.ToDateTime(dtPTo.Value));//取得dataGrid绑定的DataSet 4 if(dt==null) return; 5 DataGridTableStyle ts = dataGrid1.TableStyles[0]; 6 7 8 //-***************获取excel对象*************** 9 string saveFileName=; 10 bool fileSaved=false; 11 SaveFileDialog saveDialog=new SaveFileDialog(); 12 saveDialog.DefaultExt =xls; 13 saveDialog.Filter=Excel文件|*.xls; 14 saveDialog.FileName =导入记录查询结果 +DateTime.Today.ToString(yyyy-MM-dd); 15 saveDialog.ShowDialog(); 16 saveFileName=saveDialog.FileName; 17 if(saveFileName.IndexOf(:)0) return; //被点了取消 18 Excel.Application xlApp=new Excel.Application(); 19 if(xlApp==null) 20 { 21 MessageBox.Show(无法启动Excel，可能您的机子未安装Excel); 22 return; 23 } 24 Excel.Workbook workbook = xlApp.Workbooks.Add(true); 25 Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1]; 26 Excel.Range range; 27 28 29 string oldCaption=dataGrid1.CaptionText; 30 // 列索引，行索引，总列数，总行数 31 int colIndex = 0; 32 int RowIndex = 0; 33 int colCount = ts.GridColumnStyles.Count; 34 int RowCount=dt.Rows.Count; 35 36 37 // *****************获取数据********************* 38 dataGrid1.CaptionVisible = true; 39 dataGrid1.CaptionText = 正在导出数据; 40 // 创建缓存数据 41 object[,] objData = new object[RowCount + 1, colCount]; 42 // 获取列标题 43 foreach(DataGridColumnStyle cs in ts.GridColumnStyles) 44 { 45 objData[RowInd