User Tools

Site Tools


Guide Section: Interacting With Excel Spreadsheets | EASAP Tree: SPREADSHEET LIST Branch

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

Note: The first time the Sheet: parameter 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.

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