User and Developer Guide

User and Developer Guide

Selection Order

Selection Order

The Autofill function fills service fields based on the order that you select ranges in the worksheet.
The following figure shows the correlation between the selection order of Excel ranges and input fields in the
Use Service
window:
The figure shows highlighted columns in an Excel sheet that contain FullName, CustNumber, and PhoneNumber. The figure includes the Excel sheet column range for each field name in the Use Service window. The column range has the following syntax: Sheet1!A3:A8
The highlighted blue areas in the Excel worksheet indicate the cell ranges that you select. The numbers in the Excel worksheet indicate the order that you select the ranges. The numbers in the
Use Service
window indicate the order in which the Data Quality for Excel plug-in populates the input fields.
If you click the
Autofill
button in the Input section of the
Use Service
window, the plug-in populates the input fields with the cell ranges indicated by the corresponding numbers. The
Autofill
button is indicated by the red circle in the figure.

0 COMMENTS

We’d like to hear from you!