Get Cell Text Function

GetCellText returns text values it finds in an Excel spreadsheet.

Syntax	GetCellText(spreadsheet location, cell location)
Example	GetCellText ("C:\files\123.xls", "A3") GetCellText (Q2, "D4") where Q2 is a lookup question that returns the filename of an Excel spreadsheet. GetCellText (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.

Syntax

GetCellText(spreadsheet location, cell location)

Example

GetCellText ("C:\files\123.xls", "A3")

GetCellText (Q2, "D4") where Q2 is a lookup question that returns the filename of an Excel spreadsheet.

GetCellText (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.