| "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. "Cell_position": Specify a header cell position to apply a filter. * A cell can be specified in A1 style or R1C1 style. For example, B3 in A1 style is equivalent to R3C2 in R1C1 style. * Specify a cell that contains data. "Column_number": Specify a column to apply a filtering condition by number. Example) C1: 3, E2: 5 * The range will be automatically set at the specified cell position, and the first column in the automatically set range will be 1. "Filter_key": Set a keyword for narrowing down. * When omitted, it will be filtered by the blank and the number of data will not be acquired. "Data_search_column": Specify a column to search the number of data. Example) C1: C, E2: E * Specify a column within the filter range. "Number_of_data": Specify a variable to store the number of data that are displayed in the filter result. |
|
| Excel file with filter set and number of matched items | |
| [History] 2021/08/10: Initial release |
|
| WinActor Ver.6.1.0, Windows10(checked on August, 2021) |
|
| - |
