What types of data files can I use?

Transaction

Depending on your Winshuttle environment, data source files can be Excel worksheets, Access tables, or XML forms.

If you use an Excel binary file (.xlsb), you can use the Excel Add-in to enter data and run the script. In Studio 20.1 and all later versions, Excel binary files can be opened, and they can be run in background mode only (the mode is selected by default). The content within Excel binary files cannot be viewed in Studio preview (SpreadsheetGear).

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, Reference Data, or SQL Server tables for your data results files.

Note: The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.

If you use an Excel binary file (.xlsb), you can use the Excel Add-in to enter data and run the script. In Studio 20.1 and all later versions, Excel binary files can be opened, and they can be run in background mode only (the mode is selected by default). The content within Excel binary files cannot be viewed in Studio preview (SpreadsheetGear).

Background images in .xls files are not supported. However, background images in .xlsx files are supported.