Use the Excel Add-in for a query - 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

Studio includes the Studio Add-in for Excel. The Microsoft Excel ribbon will include a Automate Run tab.

Important: A script developer can publish a script, which embeds it in a data file. Then script runners can open the Excel data file and run the script.
Note:

If you are running 32-bit Office, consider changing to a 64-bit Office installation or adding memory for optimal performance.

Run a Query script from Excel

  1. Open the workbook in Excel, or open a new blank workbook.
  2. Click the Automate Run tab.
  3. Click Logon To Automate.

    log on to winshuttle button

  4. Click Logon To SAP, enter your credentials, and then click OK.

    log on to sap button

  5. Click the script that you want to run, if the workbook includes more than one script. Or click Open Script and browse to the script that you want to run.

    The script opens.

    query script commands

  6. If you are starting with a blank workbook, click Write Headers.
  7.  To change how the data will be downloaded, click Write Records and choose the option you want:
    • Append Data to Result File: Query will start to write new data after the last row of any existing data in the worksheet.
    • Overwrite Data in Result File: Query will overwrite any existing data. However, if downloaded data consists of fewer rows than was in the worksheet, the data in the additional rows will remain. For example, if your worksheet contains 100 rows of data and you run a query that downloads 75 rows of data, the last 25 rows will remain in the sheet.
    • Clear All Mapped Data from Result File: Starting at the Start Row, Query will clear existing data and write the new downloaded data.
  8. Click Run.
  9. To narrow the query, type a value or values in the Run time variable wizard box, and then click OK.
    Note:

    If you open a new instance of Excel, you will need to log on again.

Run the query later

To schedule a query, click Schedule, type a value or values in the Run time variable wizard box, click OK, and then fill in the scheduling details. For more information, see Schedule a Query run.

Other Run features

To run the query on a different sheet, create the sheet, and then click Write Headers.

To find out in advance how many records will be downloaded, click Number of Entries.

To download only some of the records, type a number in the # Records box, then click the arrow on the Run button and click the command that matches the number you want.

Disable the Studio Add-in for Excel

If you need to disable the Studio Add-in for Excel, do the following:

  1. In Excel, click the File tab, and then click Options.
  2. Click Add-ins.
  3. Click the Manage box, click COM Add-ins, and then click Go.
  4. Uncheck the box next to the add-in(s) you want to disable.
    • To disable the Studio Add-in for Excel, uncheck the box next to WinshuttleStudioAddin.
    • To disable Studio macros execution, uncheck the box next to WinshuttleStudioMacros.