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

Hinweis:

The LibreOffice Calc activities package is available in preview.

Beschreibung

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.

Hinweis:

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

Projektkompatibilität

Windows | Plattformübergreifend

Konfiguration

Sie können die Aktivität und ihre Eigenschaften wie folgt konfigurieren:

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

Hinweis:

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

Eigenschaften-Panel

Optionen

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

Ausgabe

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