MarketplaceStudioActivityGet Workbook Sheets Names

Create your first automation in just a few minutes.Try Studio Web

Get Workbook Sheets Names

Get Workbook Sheets Names

by FutureWorkForce

StarStarStarStarStarStarStarStarStarStar

0

Activity

Lead Request

<100

back button
back button
carouselImage0
next button
next button

Summary

Summary

Retrieve the names of all the sheets in a workbook file

Overview

Overview

Provide the path to the specific field in the input category. The activity will read the file and extract the name of all the sheets in the workbook even the hidden ones if they can be accessed. All the names will be returned in the output category in the Sheets field as an array of strings.

This activity can be used in case a sheet with an unknown name and unknown index needs to be processed or if the name of a hidden sheet needs to be retrieved.

Features

Features

Remove dependency on MS Office. Add option to discover and process hidden sheets

Additional Information

Additional Information

Dependencies

This activity uses the ClosedXML library.

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

FutureWorkForce

Visit publisher's page

Trusted Source

Technical

Updated

February 19, 2020

Works with

Studio: 20.10 - 22.10

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings