Transaction
Depending on your Automate 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 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 Automate 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 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.