How to copy rows from the excel to the datagridxl

Question

When I try to copy the rows from excel to the datagridxl(https://www.datagridxl.com/), the row is not increasing automatically. If someone knows how to fix it, please help me.

Answer 1

In the new version of DataGridXL (version 2), you can use the option expandSheetOnPaste (which is true by default):

<div id="grid" style="height:400px;"></div>

<script src="https://code.datagridxl.com/datagridxl2.js"></script>
<script>
  var grid = new DataGridXL("grid", {
    expandSheetOnPaste: true
  });
</script>

If you copy rows from Excel to your DataGridXL instance, rows should automatically be added.