Official |[Excel] Show/Hide Sheets/Rows/Columns

Operation name

Show/Hide Sheets/Rows/Columns

Function overview

Shows/Hides sheets, rows, and columns in an Excel workbook.

Properties

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
File	Required	Available	Enter the file path of the Excel workbook. The Browse button launches a file chooser that allows you to select a file.	Specify a file path of the Excel workbook with ".xlsx" or ".xlsm" extension. Note Specify an absolute path of HULFT Square Storage for the file path. With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.

Item name

Required/Optional

Use of variables

Description

Remarks

File

Required

Available

Enter the file path of the Excel workbook.

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

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

Note

Specify an absolute path of HULFT Square Storage for the file path.
With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.

Sheet settings

Item name	Required/Optional	Use of variables	Description	Remarks
Sheet list	Optional	-	Specify sheets to be shown/hidden.
Sheet list/Sheet name	Required	Available	Select or enter a sheet to be shown/hidden of the Excel file specified in File.	Case-insensitive.
Sheet list/Visible/Hidden	Required	Not available	Select visible or hidden for the sheet specified in Sheet. Visible (Default) Hidden VeryHidden	A sheet with VeryHidden set won't be displayed in the Unhide dialog in Excel.

Item name

Required/Optional

Use of variables

Description

Remarks

Sheet list

Optional

-

Specify sheets to be shown/hidden.

Sheet list/Sheet name

Required

Available

Select or enter a sheet to be shown/hidden of the Excel file specified in File.

Case-insensitive.

Sheet list/Visible/Hidden

Required

Not available

Select visible or hidden for the sheet specified in Sheet.

Visible: (Default)
Hidden
VeryHidden

A sheet with VeryHidden set won't be displayed in the Unhide dialog in Excel.

Row settings

Item name	Required/Optional	Use of variables	Description	Remarks
Row list	Optional	-	Specify rows to be shown/hidden.
Row list/Sheet name	Required	Available	Select or enter a sheet which includes rows to be shown/hidden.	Case-insensitive.
Row list/Start row	Required	Available	Enter the starting row number of the rows to be shown/hidden.	Allowed values are from 1 to 1048576. Note Enter a value not greater than the row number specified in Row list/End row.
Row list/End row	Required	Available	Enter the ending row number of the rows to be shown/hidden.	Allowed values are from 1 to 1048576. Note Enter a value not less than the row number specified in Row list/Start row.
Row list/Visible/Hidden	Required	Not available	Select visible or hidden for the rows from the starting row specified in Row list/Start row to the ending row specified in Row list/End row. Visible (Default) Hidden

Column settings

Item name	Required/Optional	Use of variables	Description	Remarks
Column list	Optional	-	Specify columns to be shown/hidden.
Column list/Sheet name	Required	Available	Select or enter a sheet which includes columns to be shown/hidden.	Case-insensitive.
Column list/Start column	Required	Available	Enter the starting column of the columns to be shown/hidden with an alphabetic character in the A1 reference style. Example: A	Allowed values are from A to XFD. Note Enter a value equal to or former than the alphabetic character specified in Column list/End column.
Column list/End column	Required	Available	Enter the ending column of the columns to be shown/hidden with an alphabetic character in the A1 reference style. Example: XFD	Allowed values are from A to XFD. Note Enter a value equal to or latter than the alphabetic character specified in Column list/Start column.
Column list/Visible/Hidden	Required	Not available	Select visible or hidden for the columns from the starting column specified in Column list/Start column to the ending column specified in Column list/End column. Visible (Default) Hidden

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.

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.

Output 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