Forum Discussion

mujji10's avatar
mujji10
New Contributor
7 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

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
Champion Level 1
7 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
    7 years ago

    Thank you sanj and msiadak

    • groovyguy's avatar
      groovyguy
      Champion Level 1
      7 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.