Supplemental libraries

This page offers useful and ready-to-use libraries as supplements to the standard ones packed in WinActor®.
Further entries to these supplements, focusing on somewhat complex operations that can be used in common but asking users to compose from the scratch, will be made available.

Excel

Name Description
ExcelOperation_ChangeSheetName Rename a sheet in an Excel file.
>Learn more
ExcelOperation_DeleteSheetByIndex Delete a sheet in an Excel file.
* Even if there are data on the specified sheet, it will be deleted without warning.
>Learn more
ExcelOperation_DeleteSheetByName Delete a sheet in an Excel file.
* Even if there are data on the specified sheet, it will be deleted without warning.
>Learn more
ExcelOperation_ClearBordersInRange Clear border lines of cells in a range.
* Only A1 style is available for specifying a range of cells.
>Learn more
ExcelOperation_AutoFill Apply AutoFill to a specified range of cells.
* Only A1 style is available for specifying a range of cells.
>Learn more
ExcelOperation_SortRange Sort a selected range in the Excel file.
* Only A1 style is available for specifying a range of cells.
* The range is not selected here. One sort key can be specified.
>Learn more
ExcelOperation_GetLastColumn Get the last column of a sheet in the Excel file.
>Learn more
ExcelOperation_SetColorFilter Set a color filter for a cell in an Excel file.
* A cell can be specified in A1 style or R1C1 style.
* After setting a color filter, you can specify a condition for the cells to be displayed by narrowing down the condition.
>Learn more
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.
>Learn more
ExcelOperation_SetFilePassword Save an Excel file with a password.
* Run this library with the target Excel file opened.
>Learn more
ExcelOperation_GetFilteredRowCount Set a conditional filter for a cell in an Excel file and get the number of search results.
>Learn more
ExcelOperation_GetBackgroundColor Get a background color (RGB value) of a cell in an Excel file.
* A cell can be specified in A1 style or R1C1 style.
>Learn more
ExcelOperation_GetTextColor Get a font color (RGB value) of a cell in an Excel file.
* A cell can be specified in A1 style or R1C1 style.
>Learn more
ExcelOperation_SetFilter_SelectAll Set a filter for a cell in an Excel file. After setting a filter, display all in the selected state.
* A cell can be specified in A1 style or R1C1 style.
>Learn more
ExcelOperation_CreatePDFDocument Save an Excel file as a PDF file.
* It may take time depending on the contents of the Excel file.
* A cell can be specified in A1 style or R1C1 style.
>Learn more
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.
>Learn more
ExcelOperation_MoveActiveCellToNextRow Move an active cell to the next row.
* If moved outside the cell range in Excel, an error will occur.
>Learn more
ExcelOperation_MoveActiveCellToNextColumn Move an active cell to the next column.
* If moved outside the cell range in Excel, an error will occur.
>Learn more
ExcelOperation_MoveActiveCellByNumberOfRows Move an active cell by a specified number of rows.
* If moved outside the cell range in Excel, an error will occur.
>Learn more
ExcelOperation_MoveActiveCellByNumberOfColumns Move an active cell by a specified number of columns.
* If moved outside the cell range in Excel, an error will occur.
>Learn more
ExcelOperation_MoveActiveCellByNumberOfRowsAndColumns Move an active cell by a specified number of rows and columns.
* If moved outside the cell range in Excel, an error will occur.
>Learn more
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.
>Learn more

Word

Name Description
WordOperation_GetTableValue Get a value in a table in a Word file.
>Learn more
WordOperation_CreatePDFDocument Save a Word file as a PDF file.
* It may take time depending on the contents of the Word file.
>Learn more

PowerPoint

Name Description
PowerPointOperation_OpenFile_BringToFront Open a PowerPoint file and bring it to the foreground.
>Learn more

File

Name Description
CopyFolder Create a copy of a folder. This library uses CopyFolder method. Files are overwritten.
* To copy a folder under the destination folder, add \ to the end of Destination_folder.
* The destination folder cannot be a subfolder of the source folder.
>Learn more
MoveFolder Move a folder.This library uses MoveFolder method.
>Learn more
BrowserOperation_ChangeZoomTo100Percent A specified browser page zoom to 100% level.
>Learn more
ReadLineInTextFile Read a target row of a text file.
>Learn more
RunCommandAsynchronously Execute the specified command by Run method.
(When executing a command by FileOperation_RunCommand library, the scenario will get paused when a pop-up dialog appears, while this library will keep the scenario running.)
>Learn more
GetFileInformation_FileSize Get a file size of the specified file.
>Learn more
WriteTextFile_Unicode Write data to a file in Unicode character encoding. If Write_mode is 0 (overwrite) and the specified file exists, it will be overwritten.
>Learn more
GetFilePathInFolder Get a creation date of a file.
>Learn more
GetFileInformation_CreationDate Get a creation date of a file.
>Learn more
GetFileInformation_LastModifiedDate Get the last modified date of a file.
>Learn more
GetTargetPathOfShortcutFile Get a link target path of a shortcut file.
>Learn more

String Operation

Name Description
ConcatenateString_AddDate Concatenate a string with today's date in 'yyyymmdd' format. A character such as underscore can be inserted between the specified string and the today's date.
>Learn more
PadNumberWithZeros Add leading zeros to the specified number of digits.
>Learn more

IE

Name Description
IEOperation_ChangeZoom Change the zoom level of the IE window.
>Learn more
IEOperation_GetAllURLs "Get all URLs displayed in IE.
>Learn more

Window

Name Description
BringWindowToFront_GetWindowTitle Bring the specified window to the front and get the window title.
>Learn more

Automatic recording

Name Description
Emulation_Shift_DownArrow Input Shift +↓keys in the specified window.
>Learn more
Emulation_Shift_UpArrow Input Shift +↑keys in the specified window.
>Learn more

Variable

Name Description
IsVariableValueNumeric Check whether the value of the variable is numeric or not.
>Learn more
IsVariableValueDate Check whether the value of the variable can be converted to date or not.
>Learn more

Arithmetic Operation

Name Description
Calculate_UpTo4DecimalPlaces Calculate the result of four arithmetic operations.
* The value can be calculated to 4 decimal places.
* The result of the division may contain a calculation error when there are many digits.
>Learn more
Product inquiryProduct inquiry