WinActor

2021.08.10
Libraries
ExcelOperation_GetValueWithValidation

Get a value of a cell in an Excel file with checking an error status on that cell.

* A cell can be specified in A1 style or R1C1 style.

Please see this precautions upon downloading this library.
Input
"Filename":
Specify an Excel file in absolute or relative path.

"Sheet_name":
Specify a sheet. When omitted, the active sheet will be used.

"Cell_position":
Specify a cell position in A1 style or R1C1 style. For example, B3 in A1 style is equivalent to R3C2 in R1C1 style.

"Value":
A variable to store the acquired value.

"Error_status":
A variable to store the error status of the specified cell. When there is an error on the cell, "True" will be stored. Otherwise, "False" will be stored.
Output
Cell value and cell error status
Details
[History]
2021/08/10: Initial release
Operating environment
WinActor Ver.6.1.0, Windows10(checked on August, 2021)
Keywords
-