Learn more
Adding a look up question to a model
Connecting a look up question to an item or assembly variable
Get Cell Text Function
GetCellText returns text values it finds in an Excel spreadsheet.
Syntax
GetCellText(spreadsheet location, cell location)
Examples:
- GetCellText ("C:\files\123.xls", "A3")
- GetCellText (Q2, "D4") where Q2 is a lookup question that returns the file name of an Excel spreadsheet.
- GetCellText (Q2, "Sheet1!D4") where Q2 is a lookup question that returns the file name of an Excel spreadsheet, and Sheet1!D4 defines the worksheet and cell location.