Open an existing Excel data file - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Studio Administrator User Guide
Topic type
Administration
Overview
How Do I
Installation
First publish date
2018
ft:lastEdition
2024-03-11
ft:lastPublication
2024-03-11T17:14:05.914572

When you create a new script, you can edit the data file.

You can open an existing data file before you start recording, or from the Data Set panel on the Map tab.

Important: Excel data files that are password-protected and .xlsb files are not supported.

You can open existing data files that contain Excel formulas and drop-down menus (data validation). You cannot add or change the formulas or menu choices while Studio is open, but you can change them later in Excel.

If the file contains PivotTables, 3-D charts, or custom XML, it opens in read-only mode. Studio versions 12.x and beyond use SpreadsheetGear, which does not support those Excel features. If you click Enable Editing, they will be removed.

  1. Open the data file in Excel to enter any data that is needed, and then close the file.
  2. Open the script in Studio.
  3. Validate the data.
  4. Click Run. The data file opens in a separate instance of Excel and the data is uploaded to or downloaded from SAP.
Note:

If you open the file in Excel and it is already open in Studio, the file will open in read-only mode.