How can SilkTest retrieve data from a single cell in an Excel spreadsheet?
SilkTest is able to retrieve data from individual columns in an Excel spreadsheet but there is a caveat in that Row 1 (one) in each column must contain a column name and column A must contain the data identifiers. This makes Row 1 and Column A unuseable for storing retrievable data. The prototype for the call is as follows:
sSQL= "SELECT `worksheet_name$`.column_name FROM `worksheet_name$` WHERE `worksheet_name$`.Identifier = "data_to_retrieve""
For example: to retrieve the Polish word for "Open" on the File | Open menu in IE7 from a spreadsheet called "BrowserTags"
the SQL query will be
sSQL= "SELECT `BrowserTags$`.Polish FROM `BrowserTags$` WHERE `BrowserTags$`.Identifier = "FileOpenClass.pbOpen""
Please note that Borland would not normally provide SQL query strings as SQL is not a Borland product.