Write Row (preview)

Write Row activity that writes a row of data to an Apple Numbers table.

UiPath.AppleNumbers.Activities.WriteRow

説明

Writes a row of data to an Apple Numbers table.

This activity writes a single row to a table, either overwriting an existing row, inserting a new row, or appending one at the end. You supply the row either as a System.Data.DataRow or as a collection of objects, and the activity returns a snapshot of the table after the write.

注:

このパッケージは、Apple Numbers がインストールされている macOS システムでのみ動作します。

プロジェクトの対応 OS

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

構成

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

• File (local path) - The path to the Apple Numbers spreadsheet file.

  • Use a File Resource - Switches to a file resource reference instead of a plain path. You can browse for a file in either mode; this only changes how the reference is stored.
  • Use Local File - Switches back to the plain path field, restoring your previous value.

• Sheet - The name of the sheet containing the table.

• Row index - The 1-based row index to write to. Row 1 is always the table's first row, including a header row if present. Required for the Overwrite and Insert write modes, and ignored for Append. The default value is 1.

• Data row - The row to write, as a System.Data.DataRow. Used when Data type is set to DataRow.

• Array row - The row to write, as an array or IEnumerable of objects. Used when Data type is set to ArrayRow.

  注:

  Numbers, booleans, and dates in the row keep their type when written; any other value is handled by Numbers as typed input, the same as if it had been typed directly into the cell.

  プラス メニューのオプションについて詳しくは、「オートメーションを設計する」をご覧ください。

プロパティ パネル

入力

• Table name - The name of the table. Defaults to the first table in the sheet if not specified.

オプション

• Data type - Which row input to use. Select one of the following options:
  • DataRow - Use the value from Data row (a System.Data.DataRow). This is the default option.
  • ArrayRow - Use the value from Array row (an array or IEnumerable of objects).
• Write mode - How to write the row. Select one of the following options:
  • Overwrite - Replaces the existing row at Row index. This is the default option.
  • Insert - Adds a new row at Row index, shifting existing rows down.
  • Append - Adds the row at the end of the table.

出力

• Table information - Information about the table after the operation, including sheet name, table name, row count, column count, and header row count.