What types of data files can I use? - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
Topic type
Administration
Installation
Overview
How Do I
First publish date
2018
ft:lastEdition
2024-05-06
ft:lastPublication
2024-05-06T08:28:10.436135

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.