Forum Discussion

mujji10's avatar
New Contributor
7 years ago

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



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.



5 Replies

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

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

  • nmrao's avatar
    Champion Level 3
    Any specific reason that you want to delete a row from excel? Or you mean to ignore the column names? If so, then you can use Start at Cell.