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
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.
@TheMan awesome solution - THX. But may I ask why you are using delay actions in the flow?
@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.
Voted up in hopes for a "clear all rows" action.
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!
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.
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!!!
Also, what column do you use for the key?
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.
@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 😀