i have a excel file on sharepoint which the bot loop on it. After executing the row it needs to delete it from this sharepoint excel file
how can i do plz
i have a excel file on sharepoint which the bot loop on it. After executing the row it needs to delete it from this sharepoint excel file
how can i do plz
There is an option to Sync your share point. Then all files will be visible in Local drive. Use the excel using excel application scope and then use Insert/Delete row activity for deleting from the excel.
its not possible to delete it in sharepoint directly ?
If you need to remove directly from SharePoint then open the excel there Select the row that needs to delete and right click and delete.(Use Ui Automation there)
i can’t find the exel delete row with UI
you can use the O365 share point files activities.
With this you can have delete range activity for files in shared location