シートを取得

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

UiPath.LibreOfficeCalc.Activities.GetSheets

注:

The LibreOffice Calc activities package is available in preview.

説明

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.

注:

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

プロジェクトの対応 OS

Windows | クロスプラットフォーム

構成

アクティビティとそのプロパティは、次のように設定できます。

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

注:

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

プロパティ パネル

オプション

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

出力

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