Defining Ranges
The Designer creates source definitions based on ranges you define in Microsoft Excel. You can define one or more ranges in a Microsoft Excel sheet. If you have multiple sheets, define at least one range for each sheet. When you import sources in the Designer, each range displays as a relational source.
You must define a range in the Designer to import the Excel source.
To define a range:
1.
Open the Microsoft Excel file.
2.
Highlight the column or group of columns of data to import.
Click Insert > Name > Define.
3
Enter a name for the selected range and click OK.
如上图
4.
If you have multiple sheets, select each sheet and repeat steps 1 to 4 to define ranges for each set of data.
5.
Click File > Save.