Excel
With this step you can perform some operations on Excel spreadsheets using the built-in Excel driver. For the list of available actions and other information, see Built-in Excel Driver.
Note The built-in Excel driver is available only for local automation device.
Properties
- Action
-
- Create File
-
Select this option to create a new Excel document.
- Open File
-
Select this option to open an existing Excel document. After you select Open File, specify the full path to the spreadsheet in Worksheet Path. For example, c:/documents/myspreadsheet.xlsx
- Visible Area
-
Specifies the number of rows and columns to show when an Excel document opens (default 45 rows and 20 columns).
Note The specified number of columns is the minimum number. The Excel driver loads either the specified number of columns or more to fill the entire screen width.