Publish a script with an 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 publish a script in Studio, you embed it in the Excel data file. Runners can then run the script from the Excel worksheet by using the Excel Add-in.

  1. Click the Run tab, and then click Publish.

    If prompted, save the file, and then click Publish again.

  2. In the Script Name box, type a descriptive name that will help runners to identify the script.
  3. If you want to embed the script in a different data file, click Browse and locate that Excel workbook.

    By default, Studio uses the data file that is already open, but you might want to embed several scripts in one data file. You can also embed both Transaction and Query scripts in the same data file.

  4. Choose the sheet that you want runners to use. To prevent runners from using a different worksheet, click the Lock icon.
  5. To replace the existing headers each time the file is opened, check the Overwrite data file headers box.
  6. Click Publish.

The data file and the script are published, and runners who open the data file can run the script.

Republish a script to the same data sheet

When published, Studio Transaction scripts do not overwrite existing versions.

To republish an updated script to the same data sheet, do one of the following:

  • In the Script name box, type a different name.
  • Remove the script:
    1. Open the data sheet.
    2. Click the Automate Run tab, and log on to Connect if necessary.
    3. Make sure that the script name is displayed in the drop-down list.
    4. Click Information, and then click Remove.
    5. Close the data sheet.

    The script can now be republished to that data sheet.