Copy Sheet

Operation name

Copy Sheet

Function overview

Copies the sheet of the specified Excel workbook.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name

Required/Optional

Use of variables

Description

Remarks

Name

Required

Not available

Enter a name that is used on the script canvas.

 

Required settings

Item name

Required/Optional

Use of variables

Description

Remarks

Copy source file

Required

Available

Enter the file path of the source Excel file.

The Browse button launches a file chooser that allows you to select a file.

  • Specify a file path of Excel workbook with ".xlsx" or ".xlsm" extension.

Note

Copy destination file

Required

Available

Enter the file path of the destination Excel file.

You can even specify the same file as the source Excel file.

The Browse button launches a file chooser that allows you to select a file.

  • Specify a file path of Excel workbook with ".xlsx" or ".xlsm" extension.

  • A new Excel workbook will be created when the specified file doesn't exist.

Note

Sheet list

Optional

-

Specify the sheet to be copied.

  • When omitted, all the sheets will be copied.

Sheet list/Copy source sheet name

Required

Available

Select or enter the sheet to be copied that is included in the Excel file specified in Copy source file.

  • Case-sensitive.

Sheet list/Copy destination sheet name

Required

Available

Enter a new name for the copied sheet that is used in the Excel file specified in Copy destination file.

  • Case-sensitive.

  • Specify a sheet name that doesn't exist in the Excel file specified in Copy destination file.

Transaction

Item name

Required/Optional

Use of variables

Description

Remarks

Execute transaction processing

Optional

Not available

Select whether or not to execute transaction processing.

Selected

Transaction processing will be executed.

Not selected

(Default)

Transaction processing won't be executed.

= Remarks =

For details, refer to Transactions for the connectors in the File category.

 

Comment

Item name

Required/Optional

Use of variables

Description

Remarks

Comment

Optional

Not available

You can write a short description of this connector.

 

Schemas

Input schema

None.

Transaction

Transaction is supported.

 

Transaction is enabled only when Execute transaction processing of Transaction is selected.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name

Description

Remarks

message_category

When an error occurs, the category of the message code corresponding to the error is stored.

  • The default value is null.

message_code

When an error occurs, the code of the message code corresponding to the error is stored.

  • The default value is null.

message_level

When an error occurs, the severity of the message code corresponding to the error is stored.

  • The default value is null.

error_type

When an error occurs, the error type is stored.

  • The default value is null.

  • The format of the error type is as follows.

    Example: java.io.FileNotFoundException

error_message

When an error occurs, the error message is stored.

  • The default value is null.

error_trace

When an error occurs, the trace information for the error is stored.

  • The default value is null.

Message codes, exception messages, and limitations

Connector

Message code

Exception message

Limitations

Messages and limitations of the Excel connector

check

check

check