Overview

You can control Excel documents using the features provided by the Excel library.
Using the features, you can create new documents or open existing documents to edit and save.

The features provided by the Excel library are as follows:

Creating new Excel documents and worksheets: NewExcel, HeadlessNewExcel, CreateExcel, CreateWorkSheet
Opening, activating, saving, closing, splitting, and getting Excel documents: OpenExcel, HeadlessOpenExcel, SaveExcel, CloseExcel, ActivateExcel, GetActiveExcel, GetExcel, SetHeadlessExcel, SplitExcel, GetSheetName, GetAllSheetNames
Selecting worksheets and areas: SelectWorkSheet, SelectRange
Getting, reading, writing, and creating areas: GetActiveRange, GetDataRange, ClearRange, ReadRange, WriteRange, MakeRange, MergeRange, SplitRange, GetRowCount, GetColCount
Applying, releasing, and aligning filters: SetFilter, SetColorFilter, ReleaseFilter, SortData
Searching, writing, and replacing strings: SearchString, ReplaceString, ReadString, WriteString
Copying, pasting, deleting and moving: CopyWorkSheet, MoveWorkSheet, DeleteWorkSheet, CopyRange, PasteRange, CopyPaste
Macro execution: ExecuteMacro
Adding, selecting, and deleting rows and columns: AddRow, AddCol, SelectRow, SelectCol, DeleteRow, DeleteCol
Importing and entering formula: ReadCellFormula, WriteCellFormula
Applying style and border: SetStyleRange, SetBorderRange
Applying and removing hide: SetHiddenRow, SetHiddenCol
Function: VLookUp
Shortcut: SendShortCut

Use Designer or File Explorer to refer to the samples of the Excel library.

• On Designer: Menu > Help > Sample > Sample > Excel

• On File Explorer: C:\Users\user\AppData\Roaming\Brity RPA Designer\samples\Excel

[Excel sample project names and related activity cards]

• Apply Filter: ReleaseFilter, SetColorFilter, SetFilter

• Apply Style: SetBoardRange, SetHiddenCol, SetHiddenRow, SetStyleRange

• Cell Formula: ReadCellFormula, WriteCellFormula

• Edit Column: AddCol, DeleteCol, GetColCount, SelectCol

• Edit Row: AddRow, DeleteRow, GetRowCount, SelectRow

• Edit WorkSheet: CopyWorkSheet, CreateWorkSheet, DeleteWorkSheet, GetAllSheetNames, GetSheetNames, SelectWorkSheet

• Excel_Filter: ReleaseFilter, SetColorFilter, SetFilter

• Excel_Style: SetBorderRange, SetHiddenCol, SetHiddenRow, SetStyleRange

• headless_Excel: HeadlessNewExcel, HeadlessOpenExcel, SetHeadlessExcel

• Manage Excel: ActivateExcel, CloseExcel, CreateExcel, GetActiveExcel, GetExcel, NewExcel, OpenExcel, SaveExcel, SplitExcel

• Manipulate Range: ClearRange, CopyRange, GetActiveRange, GetDataRange, MakeRange, MergeRange, PasteRange, ReadRange, ReadString, SelectRange, SpiltRange, WriteRange

• OpenExcel: Not_Password, Password_One, PasswordTwo

• Other Samples: CopyPaste, ExecuteMacro, ReplaceString, SearchString, SortData, WriteString

The Excel Library mainly uses the following three components:

• Excel variable: Variable assigned for an Excel file that is currently opened.

• Excel worksheet: The name of the integrated Excel document sheet.

• Excel Range: Cell range of an Excel worksheet. For example, the range between A1 and C3 can be indicated as “A1:C3,” which can be handled as a text string.

Common Properties

SHEET

You can specify information about the target worksheet.

Card properties
Properties	Type	Required	Unit	Auto-setting	Description
SheetName	Text	Y	-	Y	Specify the target sheet name. Without additional input, “ACTIVE_SHEET” is selected by default. “ACTIVE_SHEET” refers to the Excel sheet that is currently open.
Position	Text	Y	-	N	Specify the location for the processes by activities. Enter the row and column data.
Key	Text	Y	-	Y	Specify the reference range of the target area.
Range	Text	Y	-	Y	Specify the range of the target area.
Cell	Text	Y	-	Y	Specify the target cell.
MouseType	Combination box	Y	-	Y	Specify mouse events. ※ Event types - None, LeftClick, RightClick, DoubleClick, Hover

MORE OPTIONS

MORE OPTIONS properties
Properties	Type	Required	Unit	Auto-setting	Description
On Error	Combination box	N	-	N	Specify an action to carry out when an error occurs at the time of execution. - If not specified: Output errors and exit the task. - --Ignore--: Ignore the error. - --Retry--: Try the activity one more time. - --Goto--: Try the scenario for the specified time if the activity fails. - _Event: Select an event created within the project.

DESCRIPTION

Card properties
Properties	Type	Required	Unit	Auto-setting	Description
DESCRIPTION	Text	N	-	N	Enter the description for the activity card. The description entered in the DESCRIPTION field is used as the description of the activity. A representative value will be displayed in the absence of the DESCRIPTION input.

NewExcel

Overview

This activity card creates a new Excel document.

Application procedures

1.  In the [Output] Excel field, specify the variable to store the execution result.
2.  Activity cards utilize the value assigned to the variable for editing Excel documents.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Excel	Variable	Y	-	Y	Specify the variable to assign the open Excel document.
N	Invisible	Toggle button	N	-	Y	Set whether to deactivate the opened Excel document. (Default: Off)
N	Maximize	Toggle button	N	-	Y	Set whether to maximize the window for the opened Excel document. (Default: On)
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file, save it after specifying a file name, and close the Excel file.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_New_Excel_Test

Used variables

newExcel = Variable to assign the opened Excel document

Used properties

[Output] Excel = this.newExcel
Maximize = On

Remarks

This activity card is used to create a new Excel file. The file name must be entered after saving it.

Related/Similar activities

OpenExcel, CreateExcel, SaveExcel, CloseExcel

CreateExcel

Overview

This activity card creates a new Excel document.

Application procedures

In the Path field, enter the path and file name of the Excel document created.
Set the OverWrite property to select whether to overwrite any existing file with the same name.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	Path	Text	Y	-	N	Enter the path and file name of the Excel document created. The file path is empty when this activity card is used for the first time.
N	OverWrite	Toggle button	N	-	Y	Set whether to overwrite the document if an Excel document with the same name exists. (Default: Off)
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel document with the specified name in the specified path.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_CreateExcel_Test

Used variables

None

Used properties

Path = 'C:\\CreateExcel_Test'
OverWrite = True

Related/Similar activities

NewExcel, OpenExcel, SaveExcel, CloseExcel

OpenExcel

Overview

This activity card opens the Excel document in the specified path.

Application procedures

Ensure that the Excel document to open exists in the specified path.

In the Path field, enter the path and file name of the Excel document to open.
In the [Output] Excel field, specify the variable to store the execution result. (Default: RESULT). Activity cards utilize the value assigned to the variable for editing Excel documents.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Excel	Variable	Y	-	Y	Specify the variable to assign the open Excel document. (Default: RESULT) To enhance script's readability, you can define the Excel handler as the variable and enter it in the input field.
N	Path	Text	Y	-	N	Enter the path and file name of the Excel file to open.
N	Invisible	Toggle button	N	-	Y	Set whether to deactivate the opened Excel document. (Default: Off)
N	Maximize	Toggle button	N	-	Y	Set whether to maximize the window for the opened Excel document. (Default: On)
N	Execute Shell	Toggle button	N	-	Y	Set whether to open the Excel document in the same way as double-clicking the Excel file. (Default: Off)
N	ReadOnly	Toggle button	N	-	Y	Select whether to open the Excel file as read-only. (Default: Off)
N	Use Password	Toggle button	N	-	Y	Select whether to use a password. (Default: Off)
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open, and then close the previously created "CreateExcel_Test.xlsx" Excel document.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_OpenExcel_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Output] Excel = this.openExcel
Path = 'C:\\CreateExcel_Test.xlsx'

Remarks

Various properties, such as “Invisible,” “Maximize,” “Execute Shell,” “ReadOnly,” and “User Password” can be applied when opening an Excel file. For more information, see the “Card properties” section of the OpenExcel activity card.

Related/Similar activities

NewExcel, CreateExcel

SaveExcel

Overview

This excel file saves the specified Excel document.

Application procedures

Ensure that an Excel file to save has been opened.

In the [Input] Excel field, enter the variable for the Excel document to save.
To save the document in a different file name, enter the path and file name of the document in the SaveAs field.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable to assign the Excel document to save.
N	SaveAs	Text	N	-	N	To save the document with a different name, enter the path and file name.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open the previously created Excel file and write the data in the "A1:B1," "'C4:D6," and "E8:F10" areas on the specified sheet. Then, save the Excel file using a different name and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_SaveExcel_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SaveAs = 'C:\\CreateExcel_Test_SaveAs.xlsx'

Related/Similar activities

NewExcel, OpenExcel, CloseExcel

CloseExcel

Overview

This activity card closes an open Excel document.

Application procedures

Ensure that the Excel document to close has been opened.

In the [Input] Excel field, enter the variable for the Excel document to close.
Select whether to forcibly close the document regardless of the document status with the Force property.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable to assign the Excel document to close. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Force	Toggle button	N	-	Y	Select whether to forcibly close the Excel document regardless of the document status. (Default: Off)
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open the previously created Excel file and write the data in the "A1:B1," "'C4:D6," and "E8:F10" areas on the specified sheet. Then, close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_CloseExcel_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Input] Excel = this.openExcel

Related/Similar activities

NewExcel, OpenExcel, CreateExcel, SaveExcel

ActivateExcel

Overview

This activity card activates an Excel document that has been deactivated.

Application procedures

Ensure that the Excel document to activate has been opened.

In the [Input] Excel field, enter the variable for the Excel document to activate.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Specify the variable to assign the Excel document to activate.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create two new Excel documents (CreateExcel_Test_1.xlsx, CreateExcel_Test_2.xlsx) and open them. Then, activate the "CreateExcel_Test_1.xlsx” document and enter a text string in cell A1 on the specified sheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_ActivateExcel_Test

Used variables

openExcel_1 = Variable to specify the first open Excel document
openExcel_2 = Variable to specify the second open Excel document

Used properties

[Input] Excel = this.openExcel_1 (Activate the first Excel document)

Related/Similar activities

GetActiveExcel

Overview

This activity card stores the activated Excel document in a variable.

Application procedures

Ensure that the opened Excel document has been activated.

In the [Output] Excel field, enter the variable to specify the activated Excel document.
Set the Maximize property to select whether to maximize the target document window.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Excel	Variable	Y	-	Y	Specify the variable to assign the activated Excel document that will be returned as the result. (Default: RESULT)
N	Maxmize	Toggle button	N	-	Y	Set whether to maximize the window for the target Excel document.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create two new Excel documents (CreateExcel_Test_1.xlsx, CreateExcel_Test_2.xlsx) and open them. Then, check the activated Excel file, enter text in cell A1 on the specified sheet, and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_GetActiveExcel_Test

Used variables

GetActiveExcel = Variable to specify the first activated Excel document
openExcel_1 = Variable to specify the first open Excel document
openExcel_2 = Variable to specify the second open Excel document

Used properties

[Output] Excel = this.GetActiveExcel
Maximize = On

Related/Similar activities

ActivateExcel

GetExcel

Overview

This activity card fetches the Excel document with a specified file name from among the open Excel documents.

Application procedures

Ensure that the Excel document to fetch the data from has been opened.

In the [Output] Excel field, specify the variable to store the execution result.
In the FileName field, enter the file name of the target Excel document to fetch.
Set the Maximize property to select whether to maximize the target document window.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Excel	Variable	Y	-	Y	Enter the variable to assign the Excel document that will be returned as the result.
N	FileName	Text	Y	-	N	Specify the target Excel file.
N	Maximize	Toggle button	N		Y	Set whether to maximize the window for the target Excel document. (Default: On)
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create two new Excel documents (CreateExcel_Test.xlsx, CreateExcel_Test_GetExcel.xlsx) and open them. CreateExcel_Test.xlsxThen, assign the “CreateExcel_Test.xlsx” document to the “getExcel” variable, enter text in cells A1:B3 on the sheet, and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_GetExcel_Test

Used variables

getExcel = Variable to assign the fetched Excel document

Used properties

[Output] Excel = this.getExcel
FileName = 'CreateExcel_Test.xlsx'
Maximize = On

Related/Similar activities

GetActiveExcel

SplitExcel

Overview

This activity card partially or entirely copies the worksheet of a personal Excel document that contains multiple worksheets to create a new Excel document.

Application procedures

In the [Input] Excel field, enter the variable assigned with the Excel document to fetch the data from.
In the Path field, enter the path and file name to save the file.
Set the WholeSheet property to specify whether to select all worksheets in the target document.
To fetch a part of the worksheets only, enter the worksheet name in the SheetName field.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the range to be read. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Path	Text	Y	-	N	Enter the path and file name of the new Excel document.
N	WholeSheet	Toggle button	Y	-	Y	Select whether to copy the all worksheets or a part of it.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file(CreateExcel_Test.xlsx), open it, and add a new worksheet. Then, use the SpiltExcel activity card to add all or a part of the worksheets in the "CreateExcel_Test.xlsx” file to the "SpiltExcel.xlsx” file.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manage Excel > P_SplitExcel_Test

Used variables

openExcel = Variable to specify the Excel document that includes the worksheet to be fetched

Used properties

[Input] Result = this.openExcel

Related/Similar activities

SplitRange

CreateWorkSheet

Overview

This activity card adds a new worksheet to the Excel document.

Application procedures

Ensure that the Excel document to add a worksheet has been opened.

In the [Input] Excel field, enter the variable for the Excel document to add a worksheet.
In the SheetName field, enter the name or variable name for the newly created worksheet.
In the [SHEET] Position field, specify the position to create a new worksheet.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the target Excel document to add a worksheet. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Add four worksheets (CreateWorkSheet1 through 4) to the newly created Excel file (CreateExcel_Test.xlsx), verify the name of the fifth worksheet, and then close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_CreateWorkSheet_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'CreateWorkSheet1' (~ 'CreateWorkSheet4')
Position = 1

Related/Similar activities

CopyWorkSheet, DeleteWorkSheet, GetAllSheetNames, SelectWorkSheet

SelectWorkSheet

Overview

This activity card selects a specific worksheet from the Excel document.

Application procedures

Ensure that the Excel document with the worksheet to select has been opened.

In the [Input] Excel field, enter the variable for the Excel document that includes the worksheet to select.
In the SheetName field, enter the name or variable name for the worksheet to select.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document with the worksheet to select. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Add four worksheets to the newly created Excel file and select the first worksheet (worksheet name: “CreateWorkSheet1”). Then, save the file and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_SelectWorkSheet_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Input] Excel = this.openExcel

Related/Similar activities

SelectRange, SelectRow, SelectCol

CopyWorkSheet

Overview

This activity card copies a specific worksheet from an Excel document.

Application procedures

Ensure that the Excel document to copy has been opened.

In the [Input] Excel field, enter the variable for the Excel document that includes the worksheet to copy.
In the SheetName field, enter the name or variable name for the source worksheet to copy data from.
In the DestSheet field, enter the name or variable name of the worksheet to paste the copied data.
In the BeforeSheet field, enter the name or variable name for the worksheet to be placed after the copied worksheet.
In the AfterSheet field, enter the name or variable name for the worksheet to be placed before the copied worksheet.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document to copy a worksheet from. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	[SHEET] SourceSheet	Text	Y	-	Y	Enter the source worksheet to copy from. (Default: ACTIVE_SHEET) “ACTIVE_SHEET” refers to the sheet that is currently open.
N	[SHEET] DestSheet	Text	N	-	N	Enter the target worksheet to paste the copied data.
N	[SHEET] BeforeSheet	Text	Y	-	N	Enter the name of the worksheet to be placed after the target to copy. (Default: ACTIVE_SHEET) “ACTIVE_SHEET” refers to the sheet that is currently open.
N	[SHEET] AfterSheet	Text	N	-	N	Enter the name of the worksheet to be placed before the target to copy.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Add two worksheets ("CreateWorkSheet1" and "CreateWorkSheet2") to the newly created Excel file (CreateExcel_Test.xlsx). Then, copy “Sheet1” and paste it before “Sheet1,” as a worksheet named “CopyWorkSheet.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_CopyWorkSheet_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Input] Excel = this.openExcel
SourceSheet = 'Sheet1'
DestSheet = 'CopyWorkSheet'
BeforeSheet = 'Sheet1'
AfterSheet = ''

Related/Similar activities

CreateWorkSheet, SelectWorkSheet, MoveWorkSheet, DeleteWorkSheet

MoveWorkSheet

Overview

This activity card moves a specific worksheet in an Excel document.

Application procedures

Ensure that the target Excel document has been opened.

In the [Input] Excel field, enter the variable for the Excel document that includes the worksheet to move.
In the SourceSheet field, enter the name or variable name for the target worksheet to move.
In the BeforeSheet or AfterSheet field, enter the name or variable name for the worksheet that will be placed before or after the target worksheet.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document that includes the worksheet to move.
N	[SHEET] SourceSheet	Text	Y	-	Y	Enter the source worksheet to move. (Default: ACTIVE_SHEET) “ACTIVE_SHEET” refers to the sheet that is currently open.
N	[SHEET] BeforeSheet	Text	Y	-	N	Enter the name of the worksheet right before the moved worksheet within single quotation marks.
N	[SHEET] AfterSheet	Text	Y	-	N	Enter the name of the worksheet right after the moved worksheet within single quotation marks.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Remarks

Only one of the BeforeSheet or AfterSheet properties can be used to specify the worksheet position.

Related/Similar activities

CreateWorkSheet, SelectWorkSheet, CopyWorkSheet, DeleteWorkSheet

DeleteWorkSheet

Overview

This activity card deletes a specific worksheet in an Excel document.

Application procedures

Ensure that the target Excel document has been opened.

In the [Input] Excel field, enter the variable for the Excel document that includes the worksheet to delete.
In the SheetName field, enter the name or variable name for the worksheet to delete.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document that includes the worksheet to delete.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Among the two worksheets ("CreateWorkSheet1" and "CreateWorkSheet2") added to the newly created Excel file (CreateExcel_Test.xlsx), delete the second worksheet and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_DeleteWorkSheet_Test

Used variables

openExcel = Variable to specify the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'CreateWorkSheet2' (DeleteWorkSheet)
SheetName = 'CreateWorkSheet1' (~'CreateWorkSheet2') (CreateWorkSheet)
Path = 'C:\\CreateExcel_Test'

Related/Similar activities

CreateWorkSheet, SelectWorkSheet, CopyWorkSheet, MoveWorkSheet

GetSheetName

Overview

This activity card fetches the name of an Excel worksheet that matches the specified position (order). The worksheet name is returned to a variable and used for subsequent processes.

Application procedures

Ensure that the target Excel document has been opened.

In the [Output] SheetName field, enter the variable to store the worksheet name as a result.
In the [Input] Excel field, enter the variable for the Excel document that includes the target worksheet.
In the Position field, enter the order of the worksheet to fetch the name.

Card output properties

Property	Type	Additional comments	Description	Example
SheetName	String	-	Returns the worksheet name in the specified order ( Position ) in the Excel document .	'Sheet1'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to be searched for. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Fetch the first worksheet name of an Excel document specified with the “openExcel” variable and assigns it to the “this.SheetName” variable.
Add four worksheets (CreateWorkSheet1 through 4) to the newly created Excel file. If the name of the first sheet is “Sheet1,” save the Excel file with a new file name. Otherwise, generate an exception and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_GetSheetName_Test

Used variables

openExcel = Variable to specify the opened Excel document
getSheetName = Variable to store the fetched worksheet name

Used properties

[Output] SheetName = this.getSheetName
[Input] Excel = this.openExcel
Position = 1

Remarks

This activity card can be used to process data based on the Excel worksheet name or specify the worksheet name for subsequent processes.

Related/Similar activities

GetAllSheetNames

Overview

This activity card gets all worksheet names in an Excel document. The worksheet name list can be returned to a variable and used for subsequent processes.

Application procedures

Ensure that the target Excel document has been opened.

In the [Output] SheetName field, enter the variable to store the worksheet name array as the result.
In the [Input] Excel field, enter the variable for the Excel document that includes the target worksheet.
Select Visibility to enter whether to import, including hidden worksheets.

Card output properties

Property	Type	Additional comments	Description	Example
SheetNames	One-dimensional array	String	Returns all worksheet names in the corresponding Excel document..	0: 'Sheet1' 1: 'Sheet2' 2: 'Sheet3'

Property

Type

Additional comments

Description

Example

SheetNames

One-dimensional array

String

Returns all worksheet names in the corresponding Excel document..

0: 'Sheet1'

1: 'Sheet2'

2: 'Sheet3'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to be searched for. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Visibility	Select	Y	-	N	Optionally import hidden sheets contained in the integrated document. - All : Import all sheet names, including hidden sheets - OnlyVisible : Import all sheet names except hidden sheets - OnlyHidden : Import only hidden sheets
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Fetch the worksheet name array of an Excel document specified with the “openExcel” variable and assign it to the “this.getAllSheetName” variable. Add four worksheets (CreateWorkSheet1 through 4) to the newly created Excel file, read all worksheet names and output them in a message box in order, and then save the Excel file as “CreateExcel_Test_SaveAs.xlsx” and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit WorkSheet > P_GetAllSheetNames_Test

Used variables

openExcel = Variable to specify the opened Excel document
getAllSheetName = Variable to store the fetched worksheet name

Used properties

[Output] SheetName = this.getAllSheetName
[Input] Excel = this.openExcel

Remarks

This activity card is used to fetch an Excel worksheet name array and sequentially process data based on the worksheet names or utilize them for the subsequent processes.

Related/Similar activities

GetSheetName

SelectRange

Overview

This activity card selects a specific range of an Excel document. The range data can be returned to a variable and used for subsequent processes.

Application procedures

Ensure that the Excel document with the range to select has been opened.

In the [Input] Excel field, enter the variable for the Excel document to select the area.
In the SheetName field, enter the name or variable name for the worksheet to select the area.
In the Range field, specify the range to select.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable of the Excel document to select the area. (Default: RESULT)
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), select the "A6:H41" range. Then, output the selected range data in a message box, save the document, and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_SelectRange_Test

Used variables

openExcel = Variable to specify the opened Excel document
range = Variable to store the selected Excel range data

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Range = this.range (A6:H41)

Remarks

After a specific range of an Excel file has been selected, subsequent processes can be performed via shortcuts, key inputs, or menu operations.

Related/Similar activities

SelectWorkSheet, SelectRow, SelectCol

GetActiveRange

Overview

This activity card fetches the currently selected range from an Excel document.

Application procedures

Ensure that the Excel document to fetch the selected range has been opened.

In the [Output] Range field, specify the variable to store the fetched range information.
In the [Input] Excel field, enter the variable for the Excel document that includes the selected range.

Card output properties

Property	Type	Additional comments	Description	Example
Range	String	-	Returns the area information in the active state in the input Excel document.	'A1: E5'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable of the Excel document to fetch the selected range data. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Store data for the selected range, “A6:H41,” of the Excel document in the “getActRange” variable.
On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), select the cells for the "A6:H41" range. Read the current selection to verify the range value. If the range value matches the specified value, save the document with a different name. Otherwise, generate an exception and close Excel.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_GetActiveRange_Test

Used variables

openExcel: Variable to specify the open Excel document
getActRange: Variable to store the fetched range data

Used properties

[Output] Range = this.getActRange
SheetName = 'Sheet1'
Range = this.range (A6:H41)

Related/Similar activities

SelectRange, GetDataRange, ClearRange, ReadRange, WriteRange, MakeRange, MergeRange, SplitRange, CopyRange, PasteRange, CopyPaste, SetStyleRange, SetBorderRange

GetDataRange

Overview

This activity card fetches the range where data is entered in an Excel document. The range data can be returned to a variable and used for subsequent processes.

Application procedures

Ensure that the Excel document to fetch the data range has been opened.

In the [Output] Range field, specify the variable to store the returned range data.
In the [Input] Excel field, enter the variable for the Excel document that includes the data range.
In the SheetName field, enter the name or variable name for the worksheet to fetch the data range.

Card output properties

Property	Type	Additional comments	Description	Example
Range	String	-	Returns the area information where data is entered in the input Excel document.	'A1: E5'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable of the Excel document to fetch the data area. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1), “HongGildong” (C4:D6), and “Today’s date” (E8:F10) and verify the data range (A1:F10).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_GetDataRange_Test

Used variables

openExcel = Variable to assign the opened Excel document
getDataRange = Variable to store the fetched range data
sheetName = Variable that stores the worksheet name to fetch the range data from

Used properties

[Output] Range = this.getDataRange
[Input] Excel = this.openExcel
SheetName = this.sheetName

Related/Similar activities

GetActiveRange

ClearRange

Overview

This activity card deletes a specific data range of an Excel document.

Application procedures

Ensure that the Excel document to delete data has been opened.

In the [Input] Excel field, enter the variable for the Excel document to delete data.
In the SheetName field, enter the name or variable name for the worksheet to delete data.
In the Range field, specify the data range to delete.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable of the Excel document that includes the data to be deleted. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	AutoSave	Toggle button	N	-	N	Set whether to save automatically after deleting data. (Default: Off) Without an additional setting, the document will not be automatically saved.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1), “HongGildong” (C4:D6), and “Today’s date” (E8:F10). Then, search for the data range (A1:F10) and delete the data in the range.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_ClearRange_Test

Used variables

openExcel = Variable to assign the opened Excel document
getDataRange = Variable to store the fetched range data
sheetName = Variable that stores the worksheet name to fetch the range data from

Used properties

[Input] Excel = this.openExcel
SheetName = this.sheetName
Range = this.getDataRange

Related/Similar activities

SelectRange, GetActiveRange, GetDataRange, ReadRange, WriteRange, MakeRange, MergeRange, SplitRange, CopyRange, PasteRange, CopyPaste, SetStyleRange, SetBorderRange

ReadRange

Overview

This activity card reads data in the selected range from an Excel document.

Application procedures

Ensure that the Excel document to read data from has been opened.

In the [Output] DataArray field, specify the variable to store the read result.
In the [Input] Excel field, enter the variable for the Excel document that includes the data range to read.
In the ReadCellType field, select the method to read the cells in the data range.
In the SheetName field, enter the name or variable name for the worksheet that includes the data range to read.
In the Range field, specify the data range to read.

Card output properties

Property	Type	Additional comments	Description	Example
DataArray	2D Array	Object	Returns information on the area selected as Range in the input Excel document.	0: 'Col1' \| 'Col2' 1: 'Value1' \| 'Value2'

Property

Type

Additional comments

Description

Example

DataArray

2D Array

Object

Returns information on the area selected as Range in the input Excel document.

0: 'Col1' | 'Col2'

1: 'Value1' | 'Value2'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the range to be read. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	[SHEET] ReadCellType	Combination box	N	-	N	Specify the type of range to read-in. ※ Types - Data, Value, Formula, Text
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Hello” in the “A1:C3” range, and then save the data as an array. Then, output the saved array in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_ReadRange_Test

Used variables

openExcel = Variable to assign the opened Excel document
readRange = Variable to store the resulting value after reading the range.

Used properties

[Output] DataArray = this.readRange
[Input] Excel = this.openExcel
ReadCellType = Value
SheetName = 'Sheet1'
Range = 'A1:C3'

Remarks

DataArray reference method (Based on the read range)

N/A
- DateArray[0] → First row
- DataArray[0].Length → Number of first rows
- DataArray[0][1] → First row value, Second column value

Related/Similar activities

WriteRange

Overview

This activity card writes data in the selected range of an Excel file.

Application procedures

Ensure that the Excel document to write date has been opened.

In the [Input] Excel field, enter the variable for the Excel document to write data.
In the DataArray field, enter the variable assigned to the data range to write.
In the SheetName field, enter the name or variable name for the worksheet to write data.
In the StartCell field, enter the address for the cell to start data input.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Specify the variable assigned to the Excel document to write data.
N	DataArray	Text	Y	-	N	Select the variable assigned to the Excel document that includes the data range to input. Enter two-dimensional array.
N	AutoSave	Toggle button	N	-	Y	Set whether to automatically save after entering data.
N	[SHEET] StartCell	Text	Y	-	Y	Enter the name of the top-left cell for the data input within single quotation marks.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1), “HongGildong” (C4:D6), and “Today’s date” (E8:F10). Then, read the data in the “A1:B1” range and enter it in the specified cells on the specified worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_WriteRange_Test

Used variables

openExcel = Variable to assign the opened Excel document
readRange = Variable to store the resulting value after reading the range.

Used properties

[Input] Excel = this.openExcel
DataArray = this.readRange
SheetName = 'Sheet1'
StartCell = 'A20'

Related/Similar activities

ReadRange

MakeRange

Overview

This activity card specifies a range in an Excel document and assigns it to a variable.

Application procedures

In the [Output] Result field, specify the variable to store the fetched range information.
In the Range field, enter the range to specify.
In the InputValue field, enter the increment and decrement for the row and column based on the range specified with the Range property.
Set the IsRow property to select whether to change the row or column. (On: Change row / Off: Change column)
Set the IsIncrease property to select whether to increase the range.
Set the FirstAddress property to decide whether to select the address before the colon (:) if a range has been entered in the Range field, instead of a cell.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Range	Variable	Y	-	Y	Specify the variable to assign the created range. (Default: RESULT)
N	Range	Text	Y	-	N	Enter a position to start creating the area.
N	InputValue	Text	Y	-	Y	Enter the number of rows or columns to increase or decrease based on the position of the Range field.
N	IsRow	Toggle button	Y	-	Y	Specify whether to calculate rows. Set to “On” to change rows, and set to “Off” to change columns.
N	IsIncrease	Toggle button	Y	-	Y	Specify whether to increase the range. Set to “On” to increase the range, and set to “Off” to decrease it.
N	FirstAddress	Toggle button	Y	-	Y	Decide whether to set the target of the “MakeRange” activity as the starting address if a range has been entered in the Range field, instead of a cell.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1), “HongGildong” (C4:D6), and “Today’s date” (E8:F10). Then, specify the range in the Excel file, set the rows to increase and the increment, and then store the result in the “this.makeRange” variable. After that, use the WriteString activity card to input the value in the specified range (this.makeRange).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_MakeRange_Test

Used variables

openExcel = Variable to assign the opened Excel document
makeRange = Variable to store the resulting value after reading the range.

Used properties

[Output] Result = this.makeRange
Range = 'B20'
InputValue = 5
IsRow = Off
IsInclease = On
FirstAddress = Off

Remarks

This activity can be used when it is difficult to enter the cell address due to the increased number of rows or columns.

Related/Similar activities

MergeRange, SplitRange

MergeRange

Overview

This activity card merges the specified cell range in an Excel document.

Application procedures

In the [Input] Excel field, enter the variable for the Excel document that includes the specified range to merge.
Set the IncludeAllData property to select whether to include all data in the merged cell.
In the SheetName field, enter the name or variable name for the worksheet that includes the range to merge.
In the Range field, enter the range to merge.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the range to merge.
N	IncludeAllData	Toggle button	Y	-	Y	Select whether to include all data in the merged cell.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1) and “Merge Range Test” (C4:D8). Specify the “C4:F11” range as the target and merge it. After merging the cells, keep only the data in the first cell in the merged cell.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_MergeRange_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
IncludeAllData = False
SheetName = 'Sheet1'
Range = 'C4:F11'

Related/Similar activities

SplitRange

Overview

This activity card splits rows and columns of an Excel document and assigns the data to a variable as an array.

Application procedures

In the [Output] DataArray field, specify the variable to store the split array.
In the Range field, enter the range to split.

Card output properties

Property	Type	Additional comments	Description	Example
DataArray	Object	Dictionary<string, object>	Returns the result of the separated region.	When Range is 'A1:B2' { 0: A 1: 1 2: B 3: 2 }

Property

Type

Additional comments

Description

Example

DataArray

Object

Dictionary<string, object>

Returns the result of the separated region.

When Range is 'A1:B2'

{

0: A

1: 1

2: B

3: 2

}

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	Range	Text	Y	-	N	Enter the range to split.
N	Name or Number	Toggle button	N	-	Y	Select whether to receive the column data in a character or a number (A=1).
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1). Specify the range to split the rows and columns and assign it to a variable. For example, for the range of “A1:B2,” “A, 1, B, 2” will be returned as a list of text strings.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_SplitRange_Test

Used variables

OpenExcel = Variable to assign the opened Excel document.
SplitRange = Variable to store the resulting value after splitting the rows and columns.
GetDataRange: Variable to store the range data for the rows and columns to split (variable that stores the result of the “GetDataRange” activity).

Used properties

[Output] DataArray = this.splitRange
Range = this.getDataRange
Name or Number = Name

Remarks

If “A6:BB2” is entered, “A, 6, BB, 2” is assigned as an array to the “this.range” variable.

Related/Similar activities

MergeRange

CopyRange

Overview

This activity card copies a specified data range of an Excel document.

Application procedures

In the [Input] Excel field, enter the variable for the Excel document to copy the range.
In the SheetName field, enter the name or variable name for the worksheet that includes the range to copy.
In the Range field, enter the range to copy.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the range to copy. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1). Then, copy the data in the specified range and paste it in the specified range (D1:E2).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_CopyRange_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Range = 'A1:B2'

Related/Similar activities

PasteRange

Overview

This activity card pastes data range copied from an Excel file.

Application procedures

Ensure that the Excel document to paste data into has been opened.

In the [Input] Excel field, enter the variable for the Excel document that includes the worksheet to paste data into.
In the Properties window, specify the data type and operation type for the pasting and select whether to paste only cells with data and whether to switch rows and columns when pasting the data.
In the SheetName field, enter the name or variable name for the worksheet to paste data.
In the Range field, specify the data range to paste.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Select the variable assigned to the target Excel document to paste data. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Paste Type	Combination box	N	-	Y	Select the type of data to paste. ※ Types - UsingSourceTheme, Formulas, ExceptBorders, Values, ColumnWidths, Formats, FormulasAndNumberFormats, Comments, ValuesAndNumberFormats, Validation, MergingConditionalFormats
N	Paste Operation	Combination box	N	-	Y	Select the paste operation. ※ Operation types - Add, Subract, Multiply, Divide
N	PasteSkipBlanks	Toggle button	Y	-	Y	Set whether to paste only cells with data.
N	PasteTranspose	Toggle button	Y	-	Y	Set whether to switch the rows and columns of the copied range.
N	PasteUseLinks	Toggle button	Y	-	Y	Set whether to paste the link of the copied range.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “Test” (A1:B1). Copy the data in the specified range and paste it in the specified range (D1:E2).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_PasteRange_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
Paste Type = All
Paste Operation = None
PasteSkipBlanks = Off
PasteTranspose = Off
PasteUseLinks = Off
SheetName = 'Sheet1'
Range = 'D1:E2'

Remarks

The PasteRange properties correspond to the options for the “Select and paste” feature in Excel.

Related/Similar activities

CopyRange

CopyPaste

Overview

This activity card copies and pastes a specific range of an Excel document.

Application procedures

Ensure that the Excel documents to be copied and pasted have been opened.

In the [Input] SourceExcel field, enter the variable for the Excel document to copy the range.
In the [Input] DestExcel field, enter the variable for the target Excel document to paste data.
In the Properties window, specify the data type and operation type for the pasting and select whether to automatically save the target Excel document, whether to paste only cells with data, whether to switch rows and columns when pasting the data, and whether to paste the link for the copied data.
In the SourceSheet field, enter the name or variable name for the worksheet to copy the range.
In the SourceRange field, enter the range to copy.
In the DestName field, enter the name or variable name for the worksheet to paste the copied data.
In the TargetRange field, specify the data range to paste data.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	N	Enter the variable assigned to the Excel document to paste data.
N	[Input] SourceExcel	Variable	Y	-	N	Enter the variable assigned to the source Excel document to copy data.
N	PasteType	Combination box	N	-	Y	Select the type of value to paste. ※ Types - UsingSourceTheme, Formulas, ExceptBorders, Values, ColumnWidths, Formats, FormulasAndNumberFormats, Comments, ValuesAndNumberFormats, Validation, MergingConditionalFormats
N	Paste Operation	Combination box	N	-	Y	Select the paste operation type. ※ Operation types - Add, Subract, Multiply, Divide
N	DestAutoSave	Toggle button	Y	-	Y	Specify whether to automatically save the target Excel document after pasting data. (Default: Not used - gray)
N	PasteSkipBlanks	Toggle button	Y	-	Y	Set whether to paste only cells with data. (Default: Not used - gray)
N	PasteTranspose	Toggle button	Y	-	Y	Set whether to switch the rows and columns of the copied range. (Default: Not used - gray)
N	PasteUseLinks	Toggle button	Y	-	Y	Set whether to paste the link of the copied range. (Default: Not used - gray)
N	[SHEET-SourceSheet]	Text	Y	-	Y	Enter the name of the source worksheet to copy within single quotation marks.
N	[SHEET-SourceRange]	Text	Y	-	Y	Enter range to copy within single quotation marks.
N	[SHEET-DestSheet]	Text	Y	-	Y	Enter the name of the worksheet to paste data into within single quotation marks.
N	[SHEET-TargetRange]	Text	Y	-	Y	Enter the range of data to be pasted within single quotation marks.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

On the worksheet “Sheet1” in the newly created Excel file (CreateExcel_Test.xlsx), enter “TestData” (A1:B1). Copy the data in the specified range and paste it in the specified range (D1:E2).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_CopyPaste_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] SourceExcel = this.openExcel
[Input] DestExcel = this.openExcel
SourceSheet = 'Sheet1'
SourceRange = 'A1:B1'
DestSheet = 'Sheet1'
TargetRange = 'F3'
Paste Type = All
Paste Operation = None
DestAutoSave = Off
PasteSkipBlanks = Off
PasteTranspose = Off

Related/Similar activities

CopyRange, PasteRange

SetStyleRange

Overview

This activity card sets the style of the range specified in the Excel document, such as the font, alignment, background color, and cell size.

Application procedures

Ensure that the Excel document to apply the style has been opened.

In the [Input] Excel field, enter the variable for the Excel document to apply style.
In the SheetName field, enter the name or variable name for the worksheet to apply style.
In the Range field, specify the range to apply style.
Set the CELL properties to select style options, including the horizontal/vertical alignment, font size, font color, and background color.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to apply style. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	[CELL] FontName	Combination box	N	-	N	Select the name of the font.
N	[CELL] AlignHorizontal	Combination box	N	-	N	Select the horizontal alignment type. ※ Alignment types - Right, Left, Justify, Distributed, Center, General, Fill, CenterAcrossSelection
N	[CELL] AlignVertical	Combination box	N	-	N	Select the vertical alignment type. ※ Alignment types - Top, Justify, Distributed, Center, Bottom
N	[CELL] FontSize	Number	N	-	Y	Enter the font size. (Default: 0) The default value (0) stands for “no change.”
N	[CELL] FontColor	Text	N	-	Y	Enter the font color. For the color, enter the RGB numbers separated with commas (,) within single quotation marks. For example, enter 0,0,255 for blue color.
N	[CELL] BackgroundColor	Text	N	-	Y	Enter the background color of the cell. For the color, enter the RGB numbers separated with commas (,) within single quotation marks. For example, enter 0,0,255 for blue color.
N	[CELL] Width	Number	N	-	Y	Enter the cell width. (Default: 0) The default value (0) stands for “no change.”
N	[CELL] Height	Number	N	-	Y	Enter the cell height. (Default: 0) The default value (0) stands for “no change.”
N	[CELL] FontBold	Other	N	-	Y	Select whether to apply bold style to the text. “Current” stands for “the current Excel style will be maintained.”
N	[CELL] FontItalic	Other	N	-	Y	Select whether to apply Italic style to the text. “Current” stands for “the current Excel style will be maintained.”
N	[CELL] FontUnderline	Other	N	-	Y	Select whether to apply underline. “Current” stands for “the current Excel style will be maintained.”
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new file, enter “Test” in cells “A1:B2” on the “Sheet1” worksheet, and then apply style.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Style > P_SetStyleRange_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Range = 'A1:B2'
FontName = 'Arial'
AlignHorizontal = 'General'
AlignVertical = 'Center'
FontSize = '15'
FontColor = '255,0,0'
BackgroundColor = '255,255,0'
Width = '0'
Height = '0'
FontBold = 'True'
FontItalic = 'True'
FontUnderline = 'True'

Related/Similar activities

SetBorderRange

Overview

This activity card specifies the border of the area specified in an Excel document.

Application procedures

Ensure that the Excel document to apply the border has been opened.

In the [Input] Excel field, enter the variable for the Excel document to apply a border.
In the SheetName field, enter the name or variable name for the worksheet to apply a border to.
In the Range field, specify the range to apply a border.
Set the Border property to select the border type.
Set the Overlay property to choose whether to use the border over any existing borders.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to apply border. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	[CELL] Border	Combination box	N	-	N	Select the border type. ※ Border types - Bottom Border, Top Border, Left Border, Right Border, No Border, All Borders, Outside Borders, Thick Box Border, Bottom Double Border, Thick Bottom Border, Top and Bottom Border, Top and Thick Bottom Border, Top and Double Bottom Border
N	[CELL] Overlay	Toggle button	Y	-	Y	Select whether to add the border over the existing borders in the document (On) or add the border after removing any existing borders in the document (Off).
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new file, enter “Test” in cells “A1:B2” on the “Sheet1” worksheet, and then apply borders.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Style > P_SetBorderRange_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Range = 'A1:B2'
Border = All Borders
Overlay = On

Related/Similar activities

SetStyleRange

SetFilter

Overview

This activity card specifies filters for an Excel document. It can be used when filters are needed as shown in the figure below.

Excel_NewExcel_1K

Application procedures

Ensure that the Excel document to specify the filter has been opened.

In the [Output] Range field, specify the variable to store the execution result.
In the [Input] Excel field, enter the variable for the Excel document to apply filters.
In the SheetName field, enter the name or variable name for the worksheet to apply filters.
In the FilterQuery field, enter the query for the filtering.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Range	Variable	N	-	Y	Specify the variable to store the result value. A list of range resulting from the filtering is returned as the result. (Default: RESULT)
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to specify filters. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	FilterQuery	Text	N	-	N	Enter the first query value to apply to the filter within single quotation marks.
N	FilterQuery2	Text	N	-	N	Enter the second query value to apply to the filter within single quotation marks.
N	IncludeHeader	Toggle button	Y	-	Y	Set whether to include the header with filter when importing data.
N	FilterOperAND	Toggle button	N	-	Y	Select the filter query condition. If set to "On," both of the queries must be satisfied to meet the condition. If set to "Off," at least one of the two queries must be satisfied to meet the condition.
N	GetTotalRange	Toggle button	N	-	Y	Select whether to bring entire zone of data containing filter.
N	[SHEET-FilterCell]	Text	Y	-	-	Enter the cell position of the filter.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter a text string in the specified cell. Then, apply the “24344” filter to cell “B1” and output the result in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Filter > P_SetFilter_Test

Used variables

openExcel = Variable to assign the opened Excel document
setFilter = Variable to store the result after applying the filter.

Used properties

[Output] Range = this.setFilter
[Input] Excel = this.openExcel
FilterQuery = '24344'
SheetName = 'Sheet1'
FilterCell = 'B1'

Remarks

Learn more about the filter query values:

'=test' → Filter the "test" string only.

'<>test' → Filter except for the "test" string.

'=test*' → Filter strings that start with "test."

'=*test' → Filter strings that end with "test."

'=*test*' → Filter all strings that include "test."

'<>*test*' → Filter all strings that do not include "test."

'=test??' → Filter the string that starts with "test" and has two more characters in the end.

'=??test' → Filter the strings that end with "test" and have two more characters in the front.

'=??test??' → Filter all strings that have two or more characters on both sides of "test."

'<>??test??' → Filter all strings that do not contain two or more characters on both sides of "test."

'>10' → Filter only numbers larger than 10.

'>=10' → Filter only numbers equal to or larger than 10.

'<10' → Filters only the numbers smaller than 10.

Related/Similar activities

ReleaseFilter

SetColorFilter

Overview

This activity card specifies a filter for the colors or font types of cells in an Excel document.

Application procedures

Ensure that the Excel document to specify the filter has been opened.

In the [Output] Range field, specify the variable to store the execution result.
In the [Input] Excel field, enter the variable for the Excel document to apply filters.
In the Properties window, specify the color to filter and the target of the filtering (cell or font type), and then select whether to include the header.
In the SheetName field, enter the name or variable name for the worksheet to apply filters.
In the FilterCell field, enter the cell position to apply the filter.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] Range	Variable	N	-	Y	Specify the variable to store the result value. (Default: RESULT) A list of range resulting from the filtering is returned as the result.
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to specify filters. (Default: ACTIVE_SHEET) “ACTIVE_SHEET” refers to the sheet that is currently open.
N	FilterColor	Text	Y	-	Y	Specify the RGB values of the color that is to be filtered.
N	FontColor	Toggle button	Y	-	Y	Select whether to apply filter based on the font color (On) or cell color (Off).
N	IncludeHeader	Toggle button	Y	-	Y	Set whether to include the header with filter when importing data.
N	GetTotalRange	Toggle button	N	-	Y	Select whether to import the entire range of data that includes the filter.
N	UseFontAuto	Toggle button	N	-	Y	Select whether to use the default colors (On) or the RGB values (Off). When it is set to “Off,” the FilterColor property is displayed where you can enter the RGB values (Ex.: 255,255,255).
N	[SHEET-FilterCell]	Text	Y	-	-	Enter the cell position of the filter.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file, enter a text string, and apply a style. Then, apply a filter for the yellow color for cell “A1.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Filter > P_SetColorFilter_Test

Used variables

openExcel = Variable to assign the opened Excel document
setColorFilter = Variable to store the result after applying the filter.

Used properties

[Output] Range = this.setColorFilter
[Input] Excel = this.openExcel
FilterColor = '255,255,255'
FontColor = On
IncludeHeader = On
GetTotalRange = On
UseFontAuto = Off
SheetName = 'Sheet1'
FilterCell = 'A1'

Related/Similar activities

SetFilter, ReleaseFilter

ReleaseFilter

Overview

This activity card releases the filter applied to an Excel document.

Application procedures

Ensure that the filtered Excel document has been opened.

In the [Input] Excel field, enter the variable for the Excel document to release the filter.
In the SheetName field, enter the name or variable name for the worksheet to release the filter.
In the FilterCell field, enter the cell position to release the filter.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the filter to release. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	[SHEET-FilterCell]	Text	N	-	N	Enter the cell position of the filter within single quotation marks.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file, enter a text string, and apply a style. Then, release the filter applied to cell “B1.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Filter > P_ReleaseFilter_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
FilterCell = 'B1'

Related/Similar activities

SetFilter

SearchString

Overview

This activity card searches for a text string in an Excel document and reads the location of the text string if it exists in the Excel file.

Application procedures

Ensure that the Excel document to search for the text string has been opened.

In the [Output] RangeArray field, specify the variable to store the execution result.
In the [Input] Excel field, enter the variable for the Excel document to search for the text string.
In the SearchString field, enter the text string to search for.
In the SheetName field, enter the name or variable name for the worksheet to read the text string.
In the Range field, enter the search range.

Card output properties

Property	Type	Additional comments	Description	Example
RangeArray	One-dimensional array	String	Enter the variable to return the location of the searched string.	0: 'A1' 1: 'B1' 2: 'C1'

Property

Type

Additional comments

Description

Example

RangeArray

One-dimensional array

String

Enter the variable to return the location of the searched string.

0: 'A1'

1: 'B1'

2: 'C1'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the text string to search for. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	SearchString	Text	Y	-	Y	Enter the string to search for within single quotation marks.
N	ParMatch	Toggle button	N	-	Y	Select whether to allow partial search.
N	CaseMatch	Toggle button	N	-	Y	Select the case-sensitivity option.
N	Value or Formula	Toggle button	N	-	Y	Select whether to search for a value or formula.
N	[SHEET-Range]	Text	Y	-	Y	Set the range to search for the text string. (Default: 1:1048576) "1:1048576" indicates that the search will be performed from row “1” to row “1048576”.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel and enter a text string (“Test”) in the specified cell. Then, search for the entered text string (“Test”) and output the location of the cell in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_SearchString_Test

Used variables

openExcel = Variable to assign the opened Excel document
searchStr = Variable to store the location of the searched text string

Used properties

[Output] RangeArray = this.searchStr
[Input] Excel = this.openExcel
SearchString = 'Test'
SheetName = 'Sheet1'
Range = '1:1048576'

Related/Similar activities

ReplaceString

Overview

This activity card searches for a specific text string in an Excel document and replaces it with another text string.

Application procedures

Ensure that the Excel document to search for the text string has been opened.

In the [Input] Excel field, enter the variable for the Excel document to search for and replace the text string.
In the InputString field, enter the text string to search for.
In the ReplaceString field, enter the text string to replace the searched text string.
In the Range field, specify the range to search for and replace the text string.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the text string to search for. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	InputString	Text	N	-	N	Enter the string to search for within single quotation marks.
N	ReplaceString	Text	Y	-	N	Enter the string to replace the searched string within single quotation marks.
N	PartMatch	Toggle button	N	-	Y	Select whether to allow partial search. (Default: Used - blue)
N	CaseMatch	Toggle button	N	-	Y	Set whether to be case-sensitive. (Default: Not used - gray)
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel and enter a text string (“Test”) in the specified cell. Then, search for the entered text string (“Test”) and replace it with another text string (“Running”).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_ReplaceString_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
InputString = 'Test'
ReplaceString = 'Running'
SheetName = 'Sheet1'
Range = 'B1:B2'

Related/Similar activities

SearchString, ReadString, WriteString

ReadString

Overview

This activity card reads the text strings in the selected range of an Excel document.

Application procedures

Ensure that the Excel document to read the text string has been opened.

In the [Output] ReadData field, enter the variable to store the read value.
In the [Input] Excel field, enter the variable for the Excel document to read the text string.
In the SheetName field, enter the name or variable name for the worksheet to read the text string.
In the Cell field, enter the cell to read.

Card output properties

Property	Type	Additional comments	Description	Example
ReadData	String	-	The string of the selected Cell is returned.	'HongGildong'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the text string to read. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter a text string in the specified cell. Then, output the text string in cell “A1” in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Manipulate Range > P_ReadString_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Output] ReadData = RESULT
SheetName = ACTIVE_SHEET
Cell = 'A1'

Related/Similar activities

WriteString

Overview

This activity card writes a text string in the specified range of an Excel document.

Application procedures

Ensure that the Excel document to write the text string has been opened.

In the [Input] Excel field, enter the variable for the Excel document to write the text string.
In the InputString field, enter the text string to write.
In the SheetName field, enter the name or variable name for the worksheet to write the text string.
In the Range field, specify the range to write the text string.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the text string to write. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	InputString	Variable	Y	-	N	Enter the string to be entered.
N	AutoSave	Toggle button	N	-	Y	Specify whether to automatically save the Excel document after writing the text string.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter a text string in the specified cell (range).

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_WriteString_Test

Used variables

openExcel = Variable to assign the opened Excel document
var1 = Variable that stores the text string to write (Default: '홍길동')

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
InputString = 'Test' (first WriteString)
Range = 'A1:B1' (first WriteString)
InputString = this.var1 (second WriteString)
Range = 'C4:D6' (second WriteString)
InputString = '=today()' (third WriteString)
Range = 'E8:F10' (third WriteString)

Related/Similar activities

ReadString

GetMacroList

Overview

This activity card gets a list of macros from the target Excel document.

Application procedures

The Excel macro must be created in advance to use this feature.

In the [Output] field, enter a variable to get the list of macros in MacroList.
In the [Input] field, enter the variable for the Excel document to execute the macro.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Output] MacroList	Variable	Y	-	Y	Enter a variable to get the list of macros.
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the macro. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open the Excel file that includes the macro to run, get a list of macros, and run the macro (“first”).

GetMacroList

Sample file

Menu > Help > Sample > Sample > Excel > GetMacroList_Sample > ExecuteMacro_Test

Used variables

openExcel = Variable to assign the opened Excel document to

Used properties

[Intput] Excel = this.openExcel
[Output]MacroList = this.macroList

Related/Similar activities

ExecuteMacro

Overview

This activity card runs a specified macro in an Excel document.

Application procedures

The Excel macro must be created in advance to use this feature.

In the [Input] Excel field, enter the variable for the Excel document to execute the macro.
In the MacroName field, enter the name of the macro to run.
In the Parameters field, enter the necessary parameters in the macro.
In the SheetName field, enter the name or variable name for the worksheet to run the macro.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the macro. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	MacroName	String	Y	-	N	Enter the name of the macro to run.
N	Parameters	String	N	-	N	Enter the parameters required by the macro to run. If you do not have a parameter to enter, you do not have to enter it. - Enter each parameter in ''. - If you enter characters and numbers in '', it will be processed.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open the Excel file that includes the macro to run and run the macro (“first”) on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_ExecuteMacro_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Intput] Excel = this.openExcel
MacroName = 'first'
SheetName= 'Sheet1'

SendShortCut

Overview

This activity card executes shortcut features in an Excel document.

Application procedures

Ensure that the Excel document to execute the shortcut feature has been opened in advance.

In the [Input] Excel field, select the variable for the Excel document to execute the shortcut feature.
In the Keys field, enter the key input as a text string.
Specify whether to use the ALT, CTRL, and SHIFT keys.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to run the shortcut feature. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Keys	Other	Y	-	N	Enter the shortcut string within single quotation marks.
N	BeforeDelay	Other	N	Milliseconds	Y	Enter the delay time before running the shortcut feature. (Default: 1000)
N	AfterDelay	Other	N	Milliseconds	Y	Enter the delay time after running the shortcut feature. (Default: 500)
N	ShortCutName	Other	Y	-	N	Enter the shortcut name within single quotation marks.
N	ALT	Toggle button	Y	-	Y	Set to use the “ALT” key input.
N	CTRL	Toggle button	Y	-	Y	Set to use the “CTRL” key input.
N	SHIFT	Toggle button	Y	-	Y	Set to use the “SHIFT” key input.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Open the Excel and execute a SendShortCut key combination, and then close Excel.

Used variables

• openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = ACTIVE_EXCEL
Keys = 'a'
ShortCutName = 'Select all'
SheetName= 'Sheet1'

AddRow

Overview

This activity card adds a row in an Excel document.

Application procedures

Ensure that the Excel document to add a row has been opened.

In the [Input] Excel field, enter the variable for the Excel document to add a row.
In the SheetName field, enter the name or variable name for the worksheet to add a row.
In the Position field, enter the row number where the new row will be added. The row number must be expressed in the “1,” “1:2,” or “1, 2” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to add a row. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file, enter data in the cells “A1:B1” and “A2:B2” on the “Sheet1” worksheet. Then, add the second row (row #2) on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Row > P_AddRow_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = '2'

Related/Similar activities

AddCol, DeleteRow

AddCol

Overview

This activity card adds a column in an Excel document.

Application procedures

Ensure that the Excel document to add a column has been opened.

In the [Input] Excel field, enter the variable for the Excel document to add a column.
In the SheetName field, enter the name or variable name for the worksheet to add a column.
In the Position field, enter the character for the column where the new column will be added. The column character must be expressed in the “A,” “A:B,” or “A, B” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to add a column. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file, enter data in the cells “A1:B1” and “C4:D6” on the “Sheet1” worksheet. Then, add column C on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Column > P_AddCol_Test

Used variables

this.openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = 'C'

Related/Similar activities

AddRow, DeleteCol

SelectRow

Overview

This activity card selects a specific row in an Excel document.

Application procedures

Ensure that the Excel document to select a row has been opened.

In the [Input] Excel field, enter the variable for the Excel document to select a row.
In the SheetName field, enter the name or variable name for the worksheet to select a row.
In the Position field, enter the row number to select. The row number must be expressed in the “1,” “1:2,” or “1, 2” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to select a row. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter data in the specified cell. Then, select the third row (row #3) on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Row > P_SelectRow_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = '3'

Remarks

[SHEET- Position] property: Enter the row number to select within single quotation marks.

If you enter a colon ":" between the row numbers, all rows from the first-row number to the second-row number are selected.

If you enter a comma "," between the row numbers, the specified row numbers are selected.

Related/Similar activities

SelectCol

Overview

This activity card selects a specific column in an Excel document.

Application procedures

Ensure that the Excel document to select a column has been opened.

In the [Input] Excel field, enter the variable for the Excel document to select a column.
In the SheetName field, enter the name or variable name for the worksheet to select a column.
In the Position field, enter the character for the column to select. The column character must be expressed in the “A,” “A:B,” or “A, B” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to select a column. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter data in the specified cells on the “Sheet1” worksheet. Then, select the columns “B” through “E” on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Column > P_SelectCol_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = 'B:E'

Remarks

[SHEET- Position] property: Enter the column character to select within single quotation marks.

If you enter a colon ":" between the column characters, all columns from the first column character to the second column are selected.

If you enter a comma "," between the column characters, the specified column characters are all selected.

Related/Similar activities

SelectRow

DeleteRow

Overview

This activity card deletes a specific row in an Excel document.

Application procedures

Ensure that the Excel document to delete a row from has been opened.

In the [Input] Excel field, enter the variable for the Excel document to delete a row from.
In the SheetName field, enter the name or variable name for the worksheet to delete a row from.
In the Position field, enter the row number to delete. The row number must be expressed in the “1,” “1:2,” or “1, 2” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to delete a row from. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter data in the specified cell on the “Sheet1” worksheet. Then, delete the third row (row #3) on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Row > P_DeleteRow_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = '2'

Remarks

[SHEET- Position] property: Enter the row number to be deleted within single quotation marks.

If you enter a colon ":" between the row numbers, all rows from the first row number to the second row number are deleted.

If you enter a comma "," between the row numbers, the specified row numbers are deleted.

Related/Similar activities

DeleteCol, AddRow

DeleteCol

Overview

This activity card deletes a specific column in an Excel document.

Application procedures

Ensure that the Excel document to delete a column from has been opened.

In the [Input] Excel field, enter the variable for the Excel document to delete a column from.
In the SheetName field, enter the name or variable name for the worksheet to delete a column from.
In the Position field, enter the character for the column to delete. The column character must be expressed in the “A,” “A:B,” or “A, B” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to delete a column. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter data in the specified cell on the “Sheet1” worksheet. Then, delete column “B” on the “Sheet1” worksheet.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Column > P_DeleteCol_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Position = 'B'

Remarks

[SHEET- Position] property: Enter the column character to delete within single quotation marks.

If you enter a colon ":" between the column characters, all columns from the first column character to the second column character are deleted.

If you enter a comma "," between the column characters, the specified column characters are deleted.

Related/Similar activities

DeleteRow, AddCol

GetRowCount

Overview

This activity card fetches the number of rows in an Excel document.

Application procedures

Ensure that the Excel document to fetch the number of rows has been opened.

In the [Output] RowCount field, specify the variable to store the fetched result.
In the [Input] Excel field, enter the variable for the Excel document to fetch the number of rows.
In the SheetName field, enter the name or variable name for the worksheet to fetch the number of rows.

Card output properties

Property	Type	Additional comments	Description	Example
RowCount	Int	-	Returns the number of rows in a range with data in the selected Excel document.	10

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to fetch the number of rows. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter text strings in the specified cells on the “Sheet1” worksheet. Then, output the number of rows with text string inputs in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Row > P_GetRowCount_Test

Used variables

openExcel = Variable to assign the opened Excel document
getRowCnt = Variable to store the fetched number of rows

Used properties

[Output] RowCount = this.getRowCnt
[Input] Excel = this.openExcel
SheetName = 'Sheet1'

Related/Similar activities

GetColCount

Overview

This activity card fetches the number of columns in an Excel document.

Application procedures

Ensure that the Excel document to fetch the number of columns has been opened.

In the [Output] ColCount field, specify the variable to store the fetched result.
In the [Input] Excel field, enter the variable for the Excel document to fetch the number of columns.
In the SheetName field, enter the name or variable name for the worksheet to fetch the number of columns.

Card output properties

Property	Type	Additional comments	Description	Example
ColCount	Int	-	Returns the number of columns in the range with data in the selected Excel document.	6

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to fetch the number of columns. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter text strings in the specified cells on the “Sheet1” worksheet. Then, output the number of columns with text string inputs in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Edit Column > P_GetColCount_Test

Used variables

openExcel = Variable to assign the opened Excel document
getColCnt = Variable to store the fetched number of columns

Used properties

[Output] ColCount = this.getColCnt
[Input] Excel = this.openExcel
SheetName = 'Sheet1'

Related/Similar activities

GetRowCount

SetHiddenRow

Overview

This activity card hides or shows the specified row in an Excel document.

Application procedures

Ensure that the Excel document to hide or show the row has been opened.

In the [Input] Excel field, enter the variable for the Excel document to hide or show the row.
In the Rows field, enter the number for the target row. The row number must be expressed in the “1,” “1:2,” or “1, 2” format.
Set the Hidden property to select whether to hide or show the row.
In the SheetName field, enter the name or variable name for the worksheet to hide or show the row.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to hide or show the row. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Rows	Text	Y	-	N	Enter the range of rows to hide or show within two single quotation marks. For example, you can enter ‘1’ to select a specific row.
N	Hidden	Toggle button	Y	-	Y	Specify whether to hide (On) or show (Off) the row.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new file, enter “Test” in cells “A1:B5” on the “Sheet1” worksheet, and then hide cells “1:3.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Style > P_SetHiddenRow_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
Rows = '1:3'
Hidden = On
SheetName = 'Sheet1'

Related/Similar activities

SetHiddenCol

Overview

This activity card hides or shows the specified column in an Excel document.

Application procedures

Ensure that the Excel document to hide or show the column has been opened.

In the [Input] Excel field, enter the variable for the Excel document to hide or show the column.
In the Columns field, enter the character for the target column. The column character must be expressed in the “A,” “A:B,” or “A, B” format.
Set the Hidden property to select whether to hide or show the column.
In the SheetName field, enter the name or variable name for the worksheet to hide or show the column.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned for the Excel document to hide or show the column. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Columns	Text	Y	-	N	Enter the range of column to hide or show within two single quotation marks. For example, you can enter "A" to select only one column.
N	Hidden	Toggle button	Y	-	Y	Specify whether to hide (On) or show (Off) the column.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new file, enter “Test” in cells “A1:B5” on the “Sheet1” worksheet, and then hide column “A.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Apply Style > P_SetHiddenCol_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
Columns = 'A:A'
Hidden = On
SheetName = 'Sheet1'

Related/Similar activities

SetHiddenRow

SortData

Overview

This activity card sorts the specified rows or columns in ascending or descending order.

Application procedures

Ensure that the Excel document to sort the rows or columns has been opened.

In the [Input] Excel field, enter the variable for the Excel document to sort.
Set the Order property to select the sort order between an ascending or descending order.
In the SheetName field, enter the name or variable name for the worksheet to sort the rows or columns.
In the Key field, specify the reference range. The range must be expressed in the “A1:B2” format.
In the Range field, enter the target range. The range must be expressed in the “A1:B2” format.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to sort. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Order	Toggle button	N	-	Y	Specify the sort order between an ascending or descending order. (Default: Ascending order)
N	SortOrientation	Toggle button	N	-	N	Specify the reference for the sorting as column or row. (Default: ROW)
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new file, enter five fruit names in cells “A1:A5” on the “Sheet1” worksheet, and then sort them in ascending order.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Other Samples > P_SortData_Test

Used variables

openExcel = Variable to assign the opened Excel document

Used properties

[Input] Excel = this.openExcel
Order = ASC
SortOrientation = ROW
SheetName = 'Sheet1'
Key = 'A1:A5'
Range = 'A1:A5'

Related/Similar activities

SetFilter

VLookUp

Overview

This activity card executes the VLookUp feature in an Excel document. (Within an Excel document, it searches for the value of the first column of the array [list] and displays the data in that column.)

Application procedures

Ensure that the Excel document to execute the VLookUp feature has been opened.

In the [Input] Excel field, enter the variable for the Excel document to execute the VLookUp feature.
In the LookupValue field, enter the key value to search for.
In the TableRange field, enter the range of the array (table) for the search. The range must be expressed in the “A1:B2” format.
In the TableIndex field, enter the column that includes the value to fetch.
In the SheetName field, enter the name or variable name for the worksheet to execute the VLookUp feature.
In the Cell field, enter the cell to display the fetched value.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Select the variable assigned to the Excel document to execute the VLookUp feature. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	LookupValue	Text	Y	-	N	Enter key value for the search within single quotation marks.
N	TableRange	Text	Y	-	Y	Enter the range to search value within single quotation marks.
N	TableIndex	Text	Y	-	Y	Enter the location of the row including the value to fetch within the search range. (Default: 0)
N	PartMatch	Toggle button	Y	-	Y	Specify whether to find exactly matching values (On) or similar values (Off).
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Executing the feature in VLookUp.

Related/Similar activities

WriteCellFormula, ReadCellFormula

ReadCellFormula

Overview

This activity card fetches the formula used in a specific cell of an Excel document.

Application procedures

Ensure that the Excel document that has the formula to fetch has been opened.

In the [Output] Formula field, specify the variable to store the fetched result.
In the [Input] Excel field, enter the variable for the Excel document to fetch the formula.
In the SheetName field, enter the name or variable name for the worksheet to fetch the formula.
In the Cell field, enter the location of the cell to fetch the formula.

Card output properties

Property	Type	Additional comments	Description	Example
Formula	String	-	Returns the formula for the selected "Cell".	'= A1 + C4'

Card input properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable for the Excel document that includes the formula to be fetch. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter text strings in the specified cells on the “Sheet1” worksheet. Then, output the formula applied to cell “E8” on the worksheet in a message box.

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Cell Formula > P_ReadCellFormula_Test

Used variables

openExcel = Variable to assign the opened Excel document
readcellFor = Variable to store the fetched result

Used properties

[Output] Formula = this.readcellFor
[Input] Excel = this.openExcel
SheetName = 'Sheet1'
Cell = 'E8'

Related/Similar activities

WriteCellFormula

Overview

This activity card writes a formula in a specific cell of an Excel document.

Application procedures

Ensure that the Excel document to write the formula has been opened.

In the [Input] Excel field, enter the variable for the Excel document to write the formula.
In the Formula field, enter the formula or the variable for the formula to write.
In the SheetName field, enter the name or variable name for the worksheet to write the formula.
In the Cell field, enter the cell to write the formula.

Card properties

Card properties
Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Excel	Variable	Y	-	Y	Enter the variable assigned to the Excel document to write the formula. (Default: ACTIVE_EXCEL) "ACTIVE_EXCEL" refers to the Excel document that is currently open.
N	Formula	Text	Y	-	N	Enter the formula within single quotation marks.
N	AutoSave	Toggle button	N	-	Y	Specify whether to automatically save the Excel document after writing the formula.
Y	SHEET	-	-	-	-	Common property of the Excel library.
Y	MORE OPTIONS	-	-	-	-	Common property of the Excel library.
Y	DESCRIPTION	-	-	-	-	Common property of the Excel library.

Example of utilization

Create a new Excel file and enter text strings in the specified cells on the “Sheet1” worksheet. Then, apply the formula in cell “A” to cells “A2:B2.”

Excel_NewExcel_1K

Sample file

Menu > Help > Sample > Sample > Excel > Cell Formula > P_WriteCellFormula_Test

Used variables

openExcel = Variable to assign the opened Excel document
outFormula = Variable to store the fetched formula

Used properties

[Input] Excel = this.openExcel
Formula = this.outFormula
SheetName = 'Sheet1'
Cell = 'A2:B2'

Related/Similar activities

ReadCellFormula