How to configure the Excel Source Plus component to use particular worksheet when the sheet name is unknown?
If you are planning to use only the first worksheet in the Excel file, but the worksheet name is unknown then the steps below should be completed:
1) Make sure that you are using 2.0 version of COZYROC SSIS+ and up, because this feature to reference sheet by index(:index) was first introduced in our 2.0 version
2) Right-Click on the Excel Source Plus component and select Properties. Look at the screenshot below:
3) On the Properties screen enter ':1' for property Worksheet. Look at the screenshot below:
If you would like to use always the second sheet when the name is unknown then you should enter ':2' for property Worksheet.
The index for the third sheet is 3 and etc..
If the specified sheet starts with the colon(:) symbol, then the Excel Source Plus component will treat the remaining definition as a sheet index.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Excel Source Plus: How to modify the worksheet name dynamically at runtime
The source worksheet name is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired worksheet name. Right-click on the data flow canvas and select ...Excel Destination: How to modify the Excel Destination worksheet name dynamically at runtime
The destination worksheet name is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination worksheet. Right-click on data flow canvas and ...How can I get the name of a worksheet from an Excel file and rename it to a known name?
If you don't know the name of a worksheet in an Excel file and need to rename it to a known name, then watch this video.How can I dynamically modify the Excel source filename and worksheet name at runtime?
Watch this video showing how to dynamically modify the Excel source filename and worksheet name at runtime. The same technique can be used for the Excel destination filename and worksheet name.Can I use Data Flow Task Plus to write data into multiple worksheets in an Excel file?
Yes, you can use DFT+ with Excel Destination Plus to write data into multiple worksheets in an Excel File. To accomplish this, you will need to use variables and an expression to provide the sheet names to the package. For a demonstration showing how ...