User Tools

Site Tools


Guide Section: Interacting with an Excel spreadsheet | EASAP Tree: SPREADSHEET LIST branch

SHEET identifies a specific worksheet within the Excel workbook specified in its parent SPREADSHEET.

The first time Sheet: is set for a SHEET in an EASAP Builder session, there will be delay while the workbook file is interrogated for the sheet names to populate the choice list. This information is then saved for the rest of the session.

Do not use the following in an Excel sheet name, dependency calculations will fail alongside issues with the Excel Range Wizard:

  • $ or <DOLLAR SIGN>
  • & or <AMPERSAND>
  • , or <COMMA>

A sheet name in an Excel spreadsheet must not end with a space.

If an illegal character is found in a sheet name during Authoring:

  1. Change the sheet name and save spreadsheet
  2. Open the EASAP Builder
  3. Delete the offending SHEET from the Tree
  4. Remove the old spreadsheet from the Files tab
  5. Upload the new spreadsheet
  6. Run the Excel Range Wizard and select desired ranges

Optional Parameters:
Sheet:Select SHEET within spreadsheet
Additional Dependents:Comma-separated list of dependent cells beyond calculated values
Re-run dependency calculation after setting (eg. 1!A5 > Cell A5 in Sheet 1)
Password:Password for a password protected sheet within a SPREADSHEET