To have extra columns or rows in your SpreadJS instances after importing an xlsx file, we must use the setColumnCount and setRowCount methods after the file is imported using fromJson method.
Steps to Complete:
1. Create a new function called addColRow
2. Set the addColRow function after the fromJson method
Create a new function called addColRow:
To set the column and row count, use the setColumnCount and setRowCount method.
Below is setting the row and column count to both be 20.
Set the addColRow function after the fromJson method:
Note: You can test this here using our Excel IO demo: SpreadJS –Features –Excel Import Export –Excel IO