SSIS Components for Microsoft Excel

Build 24.0.8963

CreateWorksheet

Creates a new worksheet in an Excel workbook. If the workbook does not exist, the workbook will also be created.

Input

Name Type Description
File String The path to the Excel workbook.
Sheet String The name of the Excel worksheet to create inside the workbook.

The default value is sheet1.

Columnnames String Comma-separated list of column names to add to the new spreadsheet. Column names cannot contain white space.

Result Set Columns

Name Type Description
File String The name of Excel workbook that has been updated.
Sheet String The name of the Excel worksheet created inside the workbook. May be different from the sheet specified if the name conflicts with an existing sheet.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963