Copy chart Version 4 (.Net)

Action group: Excel 

Description

The action copies a chart to the specified sheet of the specified document.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Source contextFile context where the chart will be taken from.Robin.ExcelExcel contextYes
Target contextFile context where the chart will be inserted. If the parameter is not selected, the source context file will be taken.Robin.ExcelExcel contextNo
Chart nameName of the chart to be copied.Robin.String
Yes
Sheet name/indexID 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 methodThe parameter sets the identification method of the sheet to activate: via name or index.Robin.String
Yes
Column of the start cellColumn of the cell where the chart will be inserted. Column „A“ is default.Robin.String
No
Row of the start cellRow of the cell where the chart will be inserted. Row „1“ is default.Robin.Numeric
No
Paste as imageIf the value of the parameter is True, image of the copied chart will be pasted. Default is False.Robin.BooleantrueNo

Special conditions of use

None.

Example of use

Task

There is an Excel-document with a chart. Copy and paste it into a different Excel-document.

Solution

Use the "Open", "Copy chart", "Save", "Close" actions.

Implementation

  1. Assemble a robot scheme with the 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.

Result

The program robot completed successfully.

The chart was copied successfully.

  • Нет меток