DataGrid - 导出Excel文件

方法有很多,我只用了最简单的方法

1.引用 COM组件 Excel.dll

2.实现如下

public void ExportExcel(){
DataSet ds=this.DataSet;//取得dataGrid绑定的DataSet
if(ds==null) return;

string saveFileName="";
bool fileSaved=false;
SaveFileDialog saveDialog=new SaveFileDialog();
saveDialog.DefaultExt ="xls";
saveDialog.Filter="Excel文件|*.xls";
saveDialog.FileName ="Sheet1";
saveDialog.ShowDialog();
saveFileName=saveDialog.FileName;
if(saveFileName.IndexOf(":")<0) return; //被点了取消

Excel.Application xlApp=new Excel.Application();

if(xlApp==null){
MessageBox.Show("无法创建Excel对象,可能您的机子未安装Excel");
return;
}

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

string oldCaption=this.CaptionText;
long totalCount=ds.Tables[0].Rows.Count;
long rowRead=0;
float percent=0;

worksheet.Cells[1,1]=this.CaptionText;
//写入字段
for(int i=0;i

 1<ds.tables[0].columns.count;i++){ +="" +"%]...";="" application.doevents();="" for(int="" i="0;i&lt;ds.Tables[0].Columns.Count;i++){" if(ds.tables[0].columns.count="" percent="((float)(100*rowRead))/totalCount;" percent.tostring("0.00")="" r="0;r&lt;ds.Tables[0].Rows.Count;r++){" range="worksheet.get_Range(worksheet.Cells[2,1],worksheet.Cells[ds.Tables[0].Rows.Count+2,ds.Tables[0].Columns.Count]);" range.borderaround(excel.xllinestyle.xlcontinuous,excel.xlborderweight.xlthin,excel.xlcolorindex.xlcolorindexautomatic,null);="" range.borders[excel.xlbordersindex.xlinsidehorizontal].colorindex="Excel.XlColorIndex.xlColorIndexAutomatic;" range.borders[excel.xlbordersindex.xlinsidehorizontal].linestyle="Excel.XlLineStyle.xlContinuous;" range.borders[excel.xlbordersindex.xlinsidehorizontal].weight="Excel.XlBorderWeight.xlThin;" range.font.bold="true;" range.interior.colorindex="15;" rowread++;="" this.captiontext="oldCaption;" this.captionvisible="false;" worksheet.cells[2,i+1]="ds.Tables[0].Columns[i].ColumnName;" worksheet.cells[r+3,i+1]="ds.Tables[0].Rows[r][i];" }="" 写入数值="">1){   
 2range.Borders[Excel.XlBordersIndex.xlInsideVertical].ColorIndex =Excel.XlColorIndex.xlColorIndexAutomatic;   
 3range.Borders[Excel.XlBordersIndex.xlInsideVertical].LineStyle = Excel.XlLineStyle.xlContinuous;   
 4range.Borders[Excel.XlBordersIndex.xlInsideVertical].Weight = Excel.XlBorderWeight.xlThin;   
 5} 
 6
 7if(saveFileName!=""){   
 8try{   
 9workbook.Saved =true;   
10workbook.SaveCopyAs(saveFileName);   
11fileSaved=true;   
12}catch(Exception ex){   
13fileSaved=false;   
14MessageBox.Show("导出文件时出错,文件可能正被打开!\n"+ex.Message);   
15}   
16}else{   
17fileSaved=false;   
18}   
19xlApp.Quit();   
20GC.Collect();//强行销毁   
21if(fileSaved &amp;&amp; File.Exists(saveFileName)) System.Diagnostics.Process.Start(saveFileName);   
22  
23}</ds.tables[0].columns.count;i++){>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus