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:
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:
|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|