create excel worksheet
Create a new Excel worksheet.
Name | Description | Type | Modifier |
---|---|---|---|
file path | The location of the Excel file. | String | None |
sheet name | Name of the new Excel worksheet (e.g., Sheet1). | String | None |
None
This action may be used within the following project items: test modules and user-defined actions.
None
file path
open excel workbook C:\excel\data.xlsx
file path sheet name
create excel worksheet C:\excel\data.xlsx CarRental
file path auto save
close excel workbook D:\data.xlsx true
 
Result
- This action only supports Excel extensions: .xls, .xlsx, .xlsm.