| 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
|
| 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
|
Product inquiry
Product inquiry