История страницы

...

There are 2 Excel documents "Test" and "Test1". You need to take a table from the "Test" document and paste it into the "Test1" document starting from cell A3.

Image RemovedImage Added

Solution

Use the actions "Open", "Get table", " Insert table", "Save". 

...

1. Assemble a robot scheme consisting of actions:
   Image RemovedImage Added
   
   
2. Configure parameters for the "Open" action. In the "Path to file" field, specify the path to the required Excel file. Check the Open Visible = true checkbox to display robot actions on the screen. 
   Image RemovedImage Added
   
   
3. Set up parameters for the "Get table" action. In the "Context" field specify the context of the opened document, create a variable of the "Table" type to which the data will be written and specify it in the "Result" field.  Leave the other fields empty, because it is necessary to take the table completely. 
   Image RemovedImage Added
   
   
4. Configure parameters for the "Open" action. In the "Path to file" field, specify the path to the required Excel file where the table should be inserted. Check the Open Visible = true checkbox to display robot actions on the screen. 
   
   
   
5. Set up parameters for the Insert Table action. In the "Context" field specify the context of the opened document, in the "Initial cell column name" field specify - A, in the " Start cell row" field - 3. In the "Table" field specify the previously created variable "Table" with data. 
   
   
   
6. Customize parameters for the "Save" action. In the Context parameter specify the context of the Excel document where the table with data will be inserted. 
   
   
   
7. Launch the robot using the "Start" button in the top panel. 

...