Copy data from one sheet to another sheet in excel file which is in sharepoint

Help Something Else
1

Hello All,
Copy( data from one sheet to another sheet), Append Data, Write Data, Delete Rows, Add colors to rows Can we do these automations in excel file which is in share point, without downloading the excel files and after the automation uploading into share-point.
my requirement is should be automate the above scenarios directly in sharepoint.

2

it can be done only after downloading

3

I can Append data successfully and Copied the filtered data from one sheet to another sheet directly in share-point without downloading it