Récupérer des feuilles (Get Sheets)

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

UiPath.LibreOfficeCalc.Activities.GetSheets

Remarque :

The LibreOffice Calc activities package is available in preview.

Description

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.

Remarque :

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

Compatibilité du projet

Windows | Multiplate-forme

Configuration

Vous pouvez configurer l’activité et ses propriétés comme suit :

• 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.

Remarque :

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

Panneau propriétés

Options

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

Sortie

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