title: How to read entire worksheet data in excel into DataTable using ClosedXml
body: <p>Excel Worksheet contains 60K records. Needs to be read and store into DataTable. Currently reading row by row. Is there any other better way using ClosedXml.</p>
  <pre><code>DataTable dt = new DataTable();
  var wb = new XLWorkbook(fileName, XLEventTracking.Disabled);
  using (wb)
  {
      var ws = wb.Worksheet(1);
      using (ws)
      {                    
          var headerRow = ws.Row(3);
          int lastColumn = 32;
          foreach (var col in headerRow.Cells(true))
          {
              dt.Columns.Add(col.Value.ToString());
          }
          foreach (var row in ws.Rows().Skip(3))
          {
              var dr = dt.NewRow();
              for (int index = 0; index &lt; lastColumn; index++)
              {
                  dr[index] = row.Cell(index + 1).Value;
              }
              dt.Rows.Add(dr);
          }
      }
  }
  </code></pre>