使用ExcelPackage生成Excel2007电子表格

        ExcelPackage是一个在服务端生成Excel 2007 电子表格的Library. 下面的代码是生成XLSX文件示例:

  FileInfo XLSXFile = new FileInfo(XLSXFileName);
  using (ExcelPackage xlPackage = new ExcelPackage(XLSXFile))
  {
      ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("Sheet1");

      int row = 1;
      foreach (DataRow dr in dataTable.Rows)
      {
          int col = 1;

          foreach (object o in dr.ItemArray)
          {
              worksheet.Cell(row, col++).Value = o.ToString().Trim();
          }

          row++;
      }

      xlPackage.Save();
  }

是不是很简单?,希望对您有帮助!

Author: Petter Liu  http://wintersun.cnblogs.com