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 from excel

4. Loop to step 2

 

 

Currently, I am able to perform all steps except step #3

 

Any help will be appreciated.

 

Best

5 Replies

  • 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

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

  • nmrao's avatar
    nmrao
    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.