ExcelOperation_GetLastColumnOfRow
Get the last column of a row in an Excel file.
* Only A1 style is available for specifying a range of cells.
* This library gets the last column by getting 'End(xlToLeft)' property of the rightmost cell of the worksheet. This is equivalent to pressing End key and Left arrow key at the rightmost cell.
* This library doesn't work correctly when a value is set at column XFD in xlsx file.
Please see this precautions upon downloading this library.
| Input |
"Filename":
Specify an Excel file in absolute or relative path.
"Sheet_name":
Specify a name of a sheet. When omitted, the active sheet will be used.
"Search_row":
Specify a row to be searched. (Example: 3)
"Last_column":
Specify a variable to store the last column. |
|---|
| Output |
Last column number of a searched row in an Excel file |
|---|
| Details |
[History]
2021/08/02: Initial release |
|---|
| Operating environment |
WinActor Ver.6.1.0, Windows10(checked on July, 2021)
|
|---|
| Keywords |
- |
|---|
