|
Back to |
QUERY provides an add-in for Excel called the QUERY add-in. You can use the QUERY add-in to run existing queries or update the mapping of existing queries, but not to edit or create them. A query can be run from Excel if it is published to any Excel file or template from QUERY client. If TRANSACTION is also installed on your computer along with QUERY, you can use the QUERY add-in to query the data, edit it, and upload data back to SAP using TRANSACTION.
When QUERY is installed, the QUERY add-in is automatically installed in Excel.
To view the QUERY add-in in Microsoft Office Excel 2007
To view the QUERY add-in in Microsoft Excel 2003
The default values for run settings are the same as in the query file. However, at run time they can be changed.
Available only if no published file exists in the Excel file. Click Browse and select the query file to open. The file details appear automatically. You cannot type in the file path.
Lists all queries that are published in the Excel file. Select a file to see its details.
A required setting. If no value is entered, the start row is 2. The setting is not saved after run time in the Excel sheet or in the published query file.
Type the Excel column where the log message has to be returned. If left blank, the log message is written to the first cell of the last column
Select this option if all records are to be extracted
Enter the required number of records to be extracted. This gets disabled if Extract all records option is selected. This is a required field. If you do not specify a value, the value is set to 1000000.
Adds or removes the column header to the output file.
Enter a reason for the run. This is a run time setting and is not saved in the Excel sheet or in the published query file.
Click Run to execute the query and download the records.
Click on this to get the number of records that will be extracted using this query.
This bar provides the logon information. It can also be used to log off from the currently logged in system.
To run a query in Excel
In Excel 2007, each cell can accommodate 8192 characters and in Excel 2003 each cell can accommodate 1024 characters. If a long text field that was used in the query contains characters that exceed these limits, the field must be trimmed to ensure a successful download.
You can use QUERY add-in and TRANSACTION add-in together in Excel.
To download data, edit it, and upload query results from an Excel sheet
Make the necessary modifications in the downloaded records.
Also in this section New Features in Winshuttle RUNNER for QUERY versions 10.6/10.7 Getting help in Winshuttle RUNNER for QUERY Activating a Winshuttle license for Connect |