Action group: Excel
The action copies a chart to the specified sheet of the specified document.
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Source context | File context where the chart will be taken from. | Robin.Excel | Excel context | Yes |
| Target context | File context where the chart will be inserted. If the parameter is not selected, the source context file will be taken. | Robin.Excel | Excel context | No |
| Chart name | Name of the chart to be copied. | Robin.String | Yes | |
| Sheet name/index | ID of the sheet where the chart will be inserted. If the parameter is omitted, the chart will be inserted into the active sheet of the target context. | Robin.String | No | |
| Sheet identification method | The parameter sets the identification method of the sheet to activate: via name or index. | Robin.String | Yes | |
| Column of the start cell | Column of the cell where the chart will be inserted. Column „A“ is default. | Robin.String | No | |
| Row of the start cell | Row of the cell where the chart will be inserted. Row „1“ is default. | Robin.Numeric | No | |
| Paste as image | If the value of the parameter is True, image of the copied chart will be pasted. Default is False. | Robin.Boolean | true | No |
None.
There is an Excel-document with a chart. Copy and paste it into a different Excel-document.
Use the "Open", "Copy chart", "Save", "Close" actions.
2. Set the "Open 1" and "Open 2" action parameters.
3. Set the "Copy chart" action parameters. Get the chart name from the Excel-file.
4. Set the "Save" action parameters.
5. Set the "Close" action parameters.
6. Click "Start" and see the result.
The program robot completed successfully.
The chart was copied successfully.
