Open action in Apple Numbers package

Use the Open action to open a Apple Numbers spreadsheet in its default mode, either read-only or write-only.

Settings

  • Select one of the following options to open a spreadsheet:
    • Variable: Enables you to open a file by specifying a file variable.
    • Control Room file: Enables you to open a file from the Control Room.
    • Desktop file: Enables you to open a file from the device. This field also accepts the file path input as a string variable or global value.
      Note:
      • The following file formats are supported:
        • .numbers
        • .xlsx
        • .csv
        • .xlsm
        • .txt
      • A password-protected spreadsheet that requires a password to open a spreadsheet is currently not supported. However, you can perform the following steps to access a password-protected spreadsheet:
        1. Use Application > Open/ Program File action to open a file. Specify the filepath and enter the parameter (Enter password) or prompt to pass to the program.
        2. Use Wait > Wait for window action to pause until the Enter password window is displayed.
        3. Use the Simulate keystrokes action on the same window to enter the password and then press Enter key on the keyboard.
        4. Use Apple Numbers > Open action followed by actions within the Apple Numbers package that you want to automate.
  • In the Sheet name field, specify the name of the sheet to activate when the Apple Numbers spreadsheet opens.
  • In the Table name field, specify the table name for the provided sheet.

    Example, you have a sheet with name Employment type with tables as Permanent and Contractor. When you specify the sheet name you must specify the table name such as Contractor to activate the Contractor table.

    Note: When the sheet name and table name are not specified, the function will default to using the currently active sheet and the active table within that spreadsheet.
  • Select any of the following tabs to create a session:
    • Local session: Specify a session name that can be used only in the current bot.
    • Global session: Specify a session name that can be used across multiple bots, such as parent bots, child bots, and other child bots of the parent bots .
    • Variable: Specify a session variable that can be used to share that session with other child bots.