Usage of each block

Connect to Excel

Start Excel via the Excel server.
Various blocks that operate Excel can only be used while Excel is running.
Hosts and ports usually do not require any configuration changes.
The last parameter allows you to choose whether to display Excel after startup.

Quit Excel

Close Excel launched from Tsumicky.
If you put this block at the end of the program that operates Excel, you can exit Excel when you exit the program.

Create new workbook

Create a new workbook.
If you want to create a new blank workbook and perform operations on it, use this block after connecting and starting Excel.

Open workbook

Open an existing workbook file.
Specify the full path to the file name of the workbook you want to open.
If you want to open a file in a special folder such as Documents or Desktop, use the following "Special folder path" and " Specify a path in combination with the "Join path" block.

Save workbook as

Name and save your workbook.
Specify the file name with the full path.
Use this to save a newly created file or open an existing file and save it under a different name.
If you want to open a file in a special folder such as Documents or Desktop, use the following "Special folder path" and " Specify a path in combination with the "Join path" block.

Save workbook

Overwrites and saves an already saved workbook.

Update the display

Specify whether to update the display while the program is running.
You can increase the execution speed of your program by not updating the display before processing in Excel and returning to updating the display when the processing is complete.

Special folder path

Get the path of a special folder.
Specify Home/Desktop/Documents/Downloads in the folder selection parameter.

Join path

Combine two or more paths into one path.
The characters used to separate paths differ depending on the OS, but these differences can be absorbed.
Also, if you want to handle a file in a special folder, you can express the name of the file by specifying a "special folder path" block and a relative path within that folder in this block.
For example, if you want to represent the file "sample.xlsx" in the "Documents" folder, drag the blocks in the following order.

• Drag this block.
• Insert the "path of folder ..." block in the first parameter and select "Documents" from the folder choices.
• Insert a string block from the "Text" group into the second parameter, and enter "sample.xlsx" inside it.

Enter value in cell

Enter the value in the cell by specifying the row number and column number.
If you want to input a number, drag the "0" block from the "Math" group to the value parameter and rewrite the number starting from 0.
Also, if you want to enter a string, drag an empty string block from the "String" group to the value parameter and enter the string in the blank field.

Enter formula in cell

Enter the formula in the cell by specifying the row number and column number.
The formula is written in the same way as in Excel.

Get cell value

Gets the value entered in the cell.
It can be assigned to variables or used in calculation formulas.