What types of data files can I use?
Transaction
Depending on your Winshuttle environment, you can use Excel worksheets or Access tables for your data source files.
If you use an Excel binary file (.xlsb), you can use the Excel Add-in to enter data and run the script. In Studio v12 and later, Excel binary files may be opened, and they can be run in background mode only (mode is selected by default). The content within Excel binary files cannot be viewed in Studio preview (SSG).
To note, .xlsb files cannot be used as Input files in InList builders.
Background images in .xls files are not supported. However, background images are supported in .xlsx files.
Query
Depending on your Winshuttle environment, you can use Excel worksheets, Access tables, text (.txt) files, or XML forms for your data results files.
If you use an Excel binary file (.xlsb), you can use the Excel Add-in to enter data and run the script. In Studio v12 and later, Excel binary files may be opened, and they can be run in background mode only (mode is selected by default). The content within Excel binary files cannot be viewed in Studio preview (SSG).
Background images in .xls files are not supported; and, background images in .xlsx files are supported.