Help Center>Studio (Connect)

Use the Excel Add-in for a transaction

Open the data file template

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

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

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.

  1. Open the data file in Excel. Or open a blank workbook.
  2. Click the Winshuttle Run tab.
  3. Click Logon To Winshuttle.

    log on to winshuttle button

  4. Click Log on 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.

    coommands in the ribbon

  6. If you opened a blank workbook, click Write Headers.
  7. Enter the data that you want to upload.
  8. Click Run.

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

If errors occur while the script is running, Transaction continues to upload data for any remaining records. In Excel, any success and error messages that are returned from SAP are logged into the log result column, with one log per record.

Fix errors

  1. Correct the values.
  2. Click the arrow on the Run button, and then click Run Only Error Rows.

Studio Transaction uploads only the corrected records.

Run options

  • Run Specified Range: To upload only some of the rows in your data file. Use the Start Row and End Row boxes to specify the range.
  • Run and Stop on Errors: To find any sections of the script that are not working.
  • Run First 5 Rows: To run the first five rows in the data file to test the data before you start a large run.
  • Run Only Error Rows: To process rows after you have fixed the data in them.
  • Run Only Unprocessed Rows: To run rows that have been added or were not processed because the run stopped. This option can be set by the person running the script.
  • Filtered Rows: If you want to run only some of the rows in the spreadsheet, click the Specified Rows button and then click Filtered.

    Important: You must apply data filters to all columns in the spreadsheet. Select the entire header row or select one header cell, and then click the Data tab and click Filter.

Disable the Excel Add-in

If you need to disable the Studio v11 Excel Add-in or the Transaction 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 TRANSACTION box is for v10.x.
    • The WinshuttleStudioAddin is for Studio v11.