c#后台如何导出excel到本地_c#导出到excel

//导出Excel的方法

private void ExportExcel()

{

DataSet ds=dtsSelect;//数据源

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;i

{

worksheet.Cells[1,i+1]=ds.Tables[0].Columns[i].ColumnName;

}

//写入数值

for(int r=0;r

{

for(int i=0;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="00000000";

}

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

}