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.

  1. On the Extract Sheet Name step, Action tab, select Extract Sheet Name.
  2. In the Variable field, select text.

    This action extracts the name of an Excel page into a variable.