Help Center>Studio v11 (LMS) Help

Run a Query script from Excel

Studio includes the Winshuttle Studio Add-in for Excel, which adds a Winshuttle Run tab to the Microsoft Excel ribbon.

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 Winshuttle Run tab.
  3. Click Logon To Winshuttle.

    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 need to log on again.

Other Winshuttle Run features

If the script has been published in the file, click the Info button to see information about the script or to remove the script.

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.

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.

Disable the Excel Add-in

If you need to disable the Studio v11 Excel Add-in or the Query v10.x Excel Add-in, 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 for the add-ins that you want to disable:
    • The QUERY box is for v10.x.
    • The WinshuttleStudioAddin box is for Studio v11.