範囲を削除

Delete Range activity that deletes a range from a LibreOffice Calc spreadsheet.

UiPath.LibreOfficeCalc.Activities.DeleteRange

注:

The LibreOffice Calc activities package is available in preview.

説明

Deletes a range from the specified spreadsheet.

This activity deletes a range of cells from a LibreOffice Calc spreadsheet. You can clear the cells in place or delete them and shift the surrounding cells.

注:

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 delete from, for example, Sheet1. The field lists the sheets found in the selected file, and you can also type a name or an expression.
• Range - The range to delete in A1 notation, for example, A1:C10. A single cell address, for example, B2, is also accepted. If empty, the sheet's used range is used.
• Delete behavior - Indicates how the range is deleted. Select one of the following options:
  • Clear - Clears cell values and formatting in the range. This is the default option.
  • Rows - Deletes the cells in the range. The cells below the range shift upward, within the same column span. Cells outside the column span are not shifted.
  • Columns - Deletes the cells in the range. The cells to the right of the range shift leftward, within the same row span. Cells outside the row span are not shifted.

注:

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.