セルを読み込み

Read Cell activity that reads the value of a cell from a LibreOffice Calc spreadsheet.

UiPath.LibreOfficeCalc.Activities.ReadCell

注:

The LibreOffice Calc activities package is available in preview.

説明

Reads the value of a cell from the specified spreadsheet.

This activity reads a single cell from a LibreOffice Calc spreadsheet and returns its value. You specify the cell in A1 notation, for example, A1. The Cell value type option controls the type of the returned value.

注:

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.
• Sheet - The name of the sheet to read from, for example, Sheet1. The field lists the sheets found in the selected file, and you can also type a name or an expression.
• セル - A1 表記で読み取るセルです (例: B2)。

注:

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

プロパティ パネル

オプション

• Cell value type - The type to return the cell value as: text, a decimal number, a whole number, a date, a time, a date and time, or a boolean. Defaults to General, which returns the value using the type detected for the cell.

  The selected type converts the value rather than checking it, so a whole number can be read as a decimal. The activity throws an error when the value cannot be converted, for example, when text is read as a number, or a fractional value as a whole number.

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

出力

• Read cell - The data retrieved from the cell.