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 ...
sanj's avatar
sanj
Super Contributor
9 years ago

You cannot do delete form you choose the row to start from by doing the following:

so it would start from second 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.