IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
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.
sSQL= "SELECT `worksheet_name$`.column_name FROM `worksheet_name$` WHERE `worksheet_name$`.Identifier = "data_to_retrieve""
sSQL= "SELECT `BrowserTags$`.Polish FROM `