Use a data table to copy the data and perform the necessary actions and paste it in different excel.
or use 2 data tables for your operations and then you can use write range and copy the data tables to respective excels
But the question is I have to work on the open excel and check in after work I am getting that excel from the browser and I cannot save that on local drive .
Do you mean to say you are opening both the excels from browser and not downloading.
after opening them in browser you work on them and close.
Is my understanding correct?
download 1st excel from the browser and do some changes and open the browser again for 2nd excel and download the other excel and paste the data what ever the changes we have made in excel 1 and then save online .
Then you can do this, open the first excel with application scope and do necessary changes. come out of the application scope and copy that excel to a data table and from data table you directly write that excel to next excel file using read range-workbook activity
Refer the below work flow and the necessary changes you need in excel one should be edited by you in excel application scope of work flow.Sample.zip (13.3 KB)
I get it when we have excels in our local drive but the thing is I cannot save the excel in local drive I have to work on the excel while it open and and make the changes and then save back to the browser(Sharepoint).
Also, I’m not sure you can use the Excel activities unless you can use the Sharepoint as the filepath. Are you connected to the Sharepoint location? By that I mean does the folder show up in your File Explorer where the Sharepoint files are located? If so, you should be able to use that folder as your filepath to open and save the file with Excel Scope.
1st excel I have to download from the browser and need to make necessary changes and copy the data from excel 1 and then open the other excel from share point on desktop and paste the data copied in excel 1 to excel 2
I see. Sounds like you just need to do it like this, assuming you can’t save first file:
Download and Open Excel 1
Attach Window
Select Range or TypeInto "[d(ctrl)]a[u(ctrl)]" // to select All
TypeInto "[d(ctrl)]c[u(ctrl)]" // to select All
Excel Scope of Excel 2
Select Range or TypeInto // to select correct cell
TypeInto "[d(ctrl)]v[u(ctrl)]" // to select All
Save file
Although, ideally you would want to use Read Range on Excel 1 instead of Copy, then you can just use Append or Merge Data Table to join them.