Adding a look up question to a model
Connecting a look up question to an item or assembly variable
GetCellNumber returns numeric values it finds in an Excel spreadsheet.
|
Syntax |
GetCellNumber (spreadsheet location, cell location) |
|
Examples |
GetCellNumber ("C:\files\123.xls", "A3") GetCellNumber (Q2, "D4") where Q2 is a lookup question that returns the filename of an Excel spreadsheet. GetCellNumber (Q2, "Sheet1!D4") where Q2 is a lookup question that returns the filename of an Excel spreadsheet, and Sheet1!D4 defines the worksheet and cell location. |