CreateWorksheet
Creates a new worksheet within a specified Excel workbook. If the target workbook does not already exist, this procedure will create the workbook first and then add the new worksheet.
Input
| Name | Type | Description |
| File | String | The full file path to the target Excel workbook where the new worksheet will be created. If the file does not exist, it will be generated during the operation. |
| Sheet | String | The desired name for the new worksheet to be added within the Excel workbook. The name must be unique within the workbook to avoid naming conflicts.
The default value is sheet1. |
| Columnnames | String | Comma-separated list of column headers to include in the new worksheet. Each name in the list must not contain any white space characters. Format: Column1, Column2, Column3. |
Result Set Columns
| Name | Type | Description |
| File | String | Returns the name of the Excel workbook that was modified or created during the procedure execution. This helps confirm the destination file that was affected. |
| Sheet | String | Returns the final name of the worksheet that was created within the workbook. This can differ from the original input if a naming conflict required the system to rename the worksheet. |