Write from Datatable action in Apple Numbers package

The Write from Datatable action in the Apple Numbers package enables you to write data from a table variable to an active or specified table in an active sheet.

Settings

  • Use one of the following options to provide session name:
    • Session name: Enter the name of the session used to open the spreadsheet with the Open action.
    • Variable: Enter the session variable that you added in the Open action.
  • Specify whether you want to write data in the currently Active table or a Specific table. If you select the Specific table option, then enter the table name to insert data into the table (for example, Table1) .
  • Specify the first cell address from which data will be added to the table in the Cell address field. For example, A5 or B10.
  • In the Table variable field, select a table variable from the list that contains the data to be inserted into the designated Numbers table. For example, Datatable1.

When you specify the attributes mentioned above, the action will populate the designated table with data from the Table variable, beginning at the specified cell address. This data will overwrite any existing cells in the table. However, if the specified cell address combined with the dimensions of the Table variable requires more columns or rows than available, an exception will be thrown.