Get Worksheet Name From Index
  • 25 Oct 2023
  • 1 Minute to read
  • Dark
    Light

Get Worksheet Name From Index

  • Dark
    Light

Article Summary

Step Details

Introduced in Version4.0.0
Last Modified in Version7.12.0
LocationData > Excel & CSV

Overview

The Get Worksheet Name From Index step returns the name of the worksheet based on the given numerical position of that specific sheet.



Properties

Inputs

PropertyDescriptionData Type
File TypeThe type of file being used by the step.
The step supports Excel_xls and Excel_xlsx file types only.
Use Constant mapping to view the drop-down.
CsvFileType
Input Excel file to pull the data from.FileData
Worksheet IndexThe Worksheet Index to return the Name of the Worksheet
Note: The Indexing of the worksheet starts from "Zero."
Int32

Outputs

PropertyDescriptionData Type
Output             The name of the specified worksheet in the file.                        String


Related Forum Posts

Was this article helpful?