cancel
Showing results for 
Search instead for 
Did you mean: 

Delete rows actions of Excel Online

I want to delete all rows from Excel Online

for renew all in table on Excel Online

 

Currently, Excel Online have the action 'Delete a row'.

But, I want to delete all rows and get new data, add rows

Status: New
Comments
TheMan
Regular Visitor

I agree with the request, it would reduce the complexity involved in doing such a simple task.

 

The popular solution of "Excel: List rows", then "Excel: delete row" within a "Control: Apply to each" works. It gave me problems initially, however it is reliable now when using a delay between Delete a Row actions.

Captureremove all rows.JPG

 

 

venseben
Helper IV

@TheMan awesome solution - THX. But may I ask why you are using delay actions in the flow?

 

/Frank

TheMan
Regular Visitor

@venseben,  it was not running reliably. So I had to slow down the steps to ensure it would run reliably. As stated in my post.



 

Anonymous
Not applicable

Voted up in hopes for a "clear all rows" action.

Anonymous
Not applicable

I have a master spreadsheet whose table is purged and rebuilt nightly from a number of other files since entries are not only updated but added or deleted as well. Deleting the table manually, the flow takes an hour to complete. Having the flow loop through the file deleting everything first adds 4 hours to the run time. Would love to have an action that will clear it out in one step!

TheMan
Regular Visitor

@Anonymous

Delete the file, Then create a new file and import the contents from a template file waiting in the wings.
Then simply import the new data.

The only caveat is that you have to know the file path and name prior to runtime. Which in this case, I think you would.

Anonymous
Not applicable

Did you find that 20s was the right amount of time for the delay?  Can it be reduced?  I would *love* a clear rows action, but this is super useful, thanks!!!

Anonymous
Not applicable

Also, what column do you use for the key?

TheMan
Regular Visitor

@Anonymous,

If you want to clear all rows within a static file, then the Delete, create, import contents from template, import data would be more appropriate. As for a key, that is up to you, if you only want to clear single rows, then a unique key would be best. Also the delay I have works for me, you will have to play with it to see if you can get good results with a shorter delay.

Anonymous
Not applicable

@TheMan -- I was trying to get the data out of a SharePoint custom list to Excel for a Mac user, who cannot use the native "export to excel" function.  So I need to clear rows, then repopulate from the current state of the SP list.  I've taken this approach, and used the created as a key, and that seems to work 😀