Create Multiple Named Ranges in an Excel Object Print Area

You can create multiple named ranges in the print area of an Excel object in CDM. When you select a range of cells in an Excel report object worksheet and name it as a print area, you can create one or more named ranges and then use them to import the information in those ranges into a Word object.

The ability to use named ranges is useful when you have a range of information that would normally require a separate variable for each cell value in the Excel object.

You can define multiple named ranges in a print area on each worksheet in an Excel report object by giving each a unique name. You can also add the same markers as you would for the ##RS and ##RE variables (in effect, ##NR, ##NL, ##SR, ##SL, +, - and cell padding). Formatting of content within the print area is maintained when the named range variables are inserted into a Word object.

To create multiple named ranges in an Excel object print area:

1. Open the report that you want to work with.
2. Open and check out the Excel object in which you want to create a print area named range.
3. Click the Section View Mode icon in the status bar.
4. In the data worksheet, select one or more cell ranges that you want to define as a print area named range. The data worksheet is originally named Sheet1, but you can rename it if necessary.
5. To define the print area, select Page Layout > Print Area> Set Print Area.
6. To add an additional cell range to the print area, select another cell range and select Page Layout > Print Area > Add to Print Area.
7. To create a named range, select a cell range within the print area and give it a unique name, such as NamedRange01.
8. Continue selecting cell ranges within the print area and naming them to create additional named ranges.
9. Save your changes in the source Excel object.
10. Click the Default View Mode icon in the status bar.
11. Save your changes to the report and check in the source Excel object.

You can now use the multiple named ranges within the print area in a Word object to import the information in their ranges into a worksheet.