Forum Discussion

mujji10's avatar
mujji10
New Contributor
9 years ago

How to delete a row in excel using Ready API paid version

Hi,   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 ...
groovyguy's avatar
groovyguy
Community Hero
9 years ago

You might be able to leverage groovy for this, but that'd be completely independent from the functionality of Ready! API.

mujji10's avatar
mujji10
New Contributor
9 years ago

Thank you sanj and msiadak

  • groovyguy's avatar
    groovyguy
    Community Hero
    9 years ago

    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.