Obtener hojas

Get Sheets activity that gets the list of sheets in a LibreOffice Calc spreadsheet, including named ranges and database ranges.

UiPath.LibreOfficeCalc.Activities.GetSheets

Nota:

The LibreOffice Calc activities package is available in preview.

Descripción

Gets the list of sheets in the specified spreadsheet, including named ranges and database ranges.

This activity retrieves the structure of a LibreOffice Calc spreadsheet. For each sheet, it returns metadata, the used range, named ranges, and database ranges, which you can use to navigate and work with specific sheets in later operations.

Nota:

This package requires LibreOffice to be installed, and runs on Windows x64 or macOS 13.3 or later on Apple Silicon.

Compatibilidad de proyectos

Windows | Multiplataforma

Configuración

Puedes configurar la actividad y sus propiedades de la siguiente manera:

• File path - The path to the spreadsheet file (.ods, .xlsx, .csv). The field also accepts a file resource through the Use resource file option in the plus menu, which replaces this field with Resource file. When the activity is placed inside a Use Spreadsheet Document scope, this field is replaced by Spreadsheet document, which is bound to the document opened by the scope.

Nota:

For more details on the plus menu options, see Designing automations.

Panel de propiedades

Opciones

• Password - The password to open a password-protected spreadsheet file. Leave empty for unprotected files.

Salida

• Sheets - The list of sheets in the document, including metadata, named ranges, and database ranges.