Remove Worksheet by Index
- 28 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Remove Worksheet by Index
- Updated on 28 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Step Details | |
| Introduced in Version | 4.0.0 |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
Remove WorkSheet by Index Step removes an entire worksheet from an XLS or XLSX Excel file. To delete a Sheet from a file, its index must be identified. Please note that CSV files cannot be utilized for this step.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Type | Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx, and AutoSelect. | CSV File Type |
| Input | The Excel file to remove the worksheet from. | FileData |
| Worksheet Index | Index of the worksheet to remove from the excel file. | Int32 |
Outputs
| Property | Description | Data Type |
|---|---|---|
| RemoveWorksheetByName1_Output | Excel file without the worksheet that was removed. | FileData |
Was this article helpful?
