Posted 8 September 2017, 2:52 pm EST
I have made a spreadsheet in which i have taken 50 rows by setting row count property from designer & populating this rows from table in DB.
But, In case in future, rows added in Table are greater than 50, then how can i add more rows.
I think by increasing row count again through designer is not a good way.
I am also inserting new rows in DB from this sheet.
What will happen in a scenario like i want to add new row in db but rows are already full in spread sheet?
How can i generate row automatically through code? Provide me some code for doing this.
Suggest me proper way through if rows are full.
Thanks in advance.