I want to delete a row from an excel sheet using Ready API, is it possible?
I am trying to achieve below test:
1. Read all rows from excel sheet
2. Create function
3. Delete first row from excel
4. Loop to step 2
Currently, I am able to perform all steps except step #3
Any help will be appreciated.
You cannot do delete form you choose the row to start from by doing the following:
so it would start from second row!
You might be able to leverage groovy for this, but that'd be completely independent from the functionality of Ready! API.
Depending on what your use case is, you might be able to build off of the other recommendation and set up a DataSource that references the Excel sheet and pair it with a DataSource Loop. That would iterate through every row of the excel spreadsheet.