1: FileInfo XLSXFile = new FileInfo(XLSXFileName);

   2: using (ExcelPackage xlPackage = new ExcelPackage(XLSXFile))

   3: {

   4:     ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("Sheet1");

   5:  

   6:     int row = 1;

   7:     foreach (DataRow dr in dataTable.Rows)

   8:     {

   9:         int col = 1;

  10:  

  11:         foreach (object o in dr.ItemArray)

  12:         {

  13:             worksheet.Cell(row, col++).Value = o.ToString().Trim();

  14:         }

  15:  

  16:         row++;

  17:     }

  18:  

  19:     xlPackage.Save();

  20: }