Excel 导出

     Excel.Application xapp = new Excel.Application();
                xapp.Application.Workbooks.Add(true);
                Excel.Worksheet xsheet = xapp.Sheets[1];
                xsheet.Cells[1,1] = "单元格内容";
               string filepath =@"D:\XX.xls";// 文件路径及文件名;
                xsheet.SaveAs(filepath);
                        
                xapp.Workbooks.Close();
                xapp.Quit();
                System.GC.Collect();

 

 public void RenderDataTableToExcel(DataTable SourceTable)
        {
            //创建对象
            HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet();
            HSSFRow headerRow = (HSSFRow)sheet.CreateRow(0);
            //获得表头名称
            foreach (DataColumn column in SourceTable.Columns)
            {
                headerRow.CreateCell(column.Ordinal).SetCellValue(column.ColumnName);
            }
            //写入数据
            int rowIndex = 1;
            foreach (DataRow row in SourceTable.Rows)
            {
                HSSFRow dataRow = (HSSFRow)sheet.CreateRow(rowIndex);
                foreach (DataColumn column in SourceTable.Columns)
                {
                    dataRow.CreateCell(column.Ordinal).SetCellValue(row[column].ToString());
                }
                rowIndex++;
            }
            //保存
            string path = Server.MapPath("~/UpFiles/ReportResult/") + "test.xls";
            FileStream file = new FileStream(path, FileMode.Create);
            workbook.Write(file);
            //关闭文件，释放对象
            file.Close();
            sheet = null;
            headerRow = null;
            workbook = null;
        }