Use the Excel Add-in for a query - Automate_Studio - 20.3

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.

   

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

   

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.

   

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.