WinActor

2021.08.17
Libraries
ExcelOperation_GetValue_ByRowAndColumnNumber

Get a value of a cell in an Excel file.

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

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.

"Row":
Specify a row of a cell. For example, 3 in A1 style is equivalent to R3 in R1C1 style.

"Column":
Specify a column of a cell. For example, B in A1 style is equivalent to C2 in R1C1 style and 2 by number.

"Value":
Specify a variable to store the acquired value.
* If it is longer than 1024 characters, it will be truncated to 1024 characters.
Output
Value of a cell
Details
[History]
2021/08/17: Initial release
Operating environment
WinActor Ver.6.1.0, Windows10(checked on August, 2021)
Keywords
number, excel, column, output, matrix, number of rows, number of columns, rows, row number, column number