c导出Excel.docVIP

private void ExportExcel() { DBCoon db = new DBCoon(); String sql = select * from goodsin; DataSet ds = db.GetDataSet(sql); 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 //写入字段 for(int i=0;ids.Tables[0].Columns.Count;i++) { worksheet.Cells[1,i+1]=ds.Tables[0].Columns[i].ColumnName; } //写入数值 for(int r=0;rds.Tables[0].Rows.Count;r++) { for(int i=0;ids.Tables[0].Columns.Count;i++) { worksheet.Cells[r+2,i+1]=ds.Tables[0].Rows[r][i]; } System.Windows.Forms.Application.DoEvents(); } worksheet.Columns.EntireColumn.AutoFit();//列宽自适应。 /*if(cmbxType.Text!=Notification) { Excel.Range rg=worksheet.get_Range(worksheet.Cells[2,2],worksheet.Cells[ds.Tables[0].Rows.Count+1,2]); rg.NumberFormat }*/ if(saveFileName!=) { try { workbook.Saved =true; workbook.SaveCopyAs(saveFileName); fileSaved=true; } catch(Exception ex) { fileSaved=false; MessageBox.Show(导出文件时出错,文件可能正被打开！\n+ex.Message); } } else { fileSaved=false; } xlApp.Quit(); GC.Collect();//强行销毁 if(fileSaved System.IO.File.Exists(saveFileName)) System.Diagnostics.Process.Start(saveFileName); //打开EXCEL 需要在COM组件中找到Microsoft excel 11.0(不同的版本可能不同，我的是office2003).添加该引用。然后在程序中using Excel