Usage of each block

Add a sheet

Add a sheet to a book.
The book to which you want to add the sheet is specified in the "Book" group block.

Active Sheet

This block indicates the active sheet.
The target book is specified in the "Book" group block.

Activate Sheet

Activates a specific sheet in a book.
The target book is specified in the "Book" group block.

Specify sheet by number

This block indicates a specific sheet in a book by number.
The target book is specified in the "Book" group block.

Specify sheet by name

This block is used to indicate a specific sheet in a workbook by name.
The target workbook is specified in the "Book" group block.

A series of operations on a sheet

Perform a series of operations in a block on a specific sheet.
The target sheet is specified in the "Book" and "Sheet" blocks.

A series of operations for all sheets

All sheets in the book are operated on in order, and the series of operations in the block are executed.
The target book is specified in the block of the "Book" block.

Target sheet

This block represents the target sheet in the "Set of operations for sheets" and "Set of operations for all sheets" blocks.

Set sheet name

Set the name of the sheet.
The target sheet is specified in blocks such as "Specify sheet by number" and "Specify sheet by name".

Sheet name

Gets the name of the sheet.
The sheet to be retrieved is specified in a block such as "Specify sheet by number" or "Specify sheet by name".

Sheet index

Gets the sheet number.
The sheet to be retrieved is specified in a block such as "Specify sheet by number" or "Specify sheet by name".

Book to which the sheet belongs

Get the book to which the sheet belongs.

Specify the sheet to be retrieved using a block such as "Specify sheet by number" or "Specify sheet by name".

Set sheet tab color

Set the sheet tab color.
The target sheet is specified in a block such as "Specify sheet by number" or "Specify sheet by name".

Reset sheet tab color

Resets the color of the sheet tab.
The target sheet is specified in a block such as "Specify sheet by number" or "Specify sheet by name".

List of sheets

Gets a list of sheets contained in the workbook.
Combined with the "Execute for each item in the list" block in the "Repeat" group, you can process all sheets in order.
Specify the target workbook in the block of the "Workbook" block.

Number of sheets

Gets the number of sheets contained in the workbook.
The target book is specified in the "Book" block.