Extract a Sheet Name
The Extract Sheet Name step is used to extract the name of a sheet. This step is useful when combined with a Test Value step to skip a sheet with a given name while looping over all sheets. This step is also useful to extract a sheet name to an attribute of a variable of complex type so that it becomes part of a returned value.
- On the Extract Sheet Name step, Action tab, select Extract Sheet Name.
-
In the Variable field, select
text.
This action extracts the name of an Excel page into a variable.