将中DataSet的数据导出为EXCEL文件

将中DataSet的数据导出为EXCEL文件

将中DataSet的数据导出为EXCEL文件 /**//// <summary>

/// 执行导出 ,请在项目中先引用Mircorsoft Excel library 11.0

/// </summary>

/// <param name='ds'>要导出的DataSet</param>

/// <param name='strExcelFileName'>要导出的文件名</param>

private void doExport(DataSet ds,string strExcelFileName)

{

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

// Excel.Workbook obj=new Excel.WorkbookClass();

// obj.SaveAs('c:\zn.xls',Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);

int rowIndex=1;

int colIndex=0;

excel.Application.Workbooks.Add(true);

System.Data.DataTable table=ds.Tables[0] ;

foreach(DataColumn col in table.Columns)

{

colIndex++;

excel.Cells[1,colIndex]=col.ColumnName;

}

foreach(DataRow row in table.Rows)

{

rowIndex++;

colIndex=0;

foreach(DataColumn col in table.Columns)

{

colIndex++;

excel.Cells[rowIndex,colIndex]=row[col.ColumnName].ToString();

}

}

excel.Visible=false;

//excel.Sheets[0] = 'sss';

excel.ActiveWorkbook.SaveAs(strExcelFileName+'.XLS',Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null,null);

//wkbNew.SaveAs strBookName

//excel.Save(strExcelFileName);

excel.Quit();

excel=null;

GC.Collect();//垃圾回收

}

#endregion