cancel
Showing results for 
Search instead for 
Did you mean: 

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

New Contributor

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 5
Super Contributor

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

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

so it would start from second row!

selctrowstart.PNG

Community Hero

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

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




---

Click the Accept as Solution button if my answer has helped, and remember to give kudos where appropriate too!
New Contributor

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

Thank you sanj and msiadak

Community Hero

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

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. 




---

Click the Accept as Solution button if my answer has helped, and remember to give kudos where appropriate too!
Community Hero

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

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.


Regards,
Rao.
New Here?
Join us and watch the welcome video:
Top Kudoed Authors