Utility Scripts

As stated earlier in this book, Andy Tinkham developed and we utilized a utility script that converts the contents of an Excel spreadsheet to an SQABasic sequential text file. For those of you not utilizing Rational Robot, this script will not be of much use except that you may be able to see how Andy Tinkham, the original developer of the Excel access routines, built his portion of the code. For those of you who are using Rational Robot, the Convert script demonstrates not only how to access an Excel spreadsheet but also how to build and use the very powerful dialog box functions supported by SQABasic.

The Convert procedure allows you to select the pathname of the input .xls file. Notice the built-in browser buttons on the dialog ...

Get Just Enough Software Test Automation now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.