Create a Print Area Named Range Variable in an Excel Object

You can create a print area named range variable in 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 a named range and then use it to import the information in that range 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 only one print area on each worksheet in an Excel report object. Any print areas added to a print area already defined on a worksheet are not generated, only the first print area is generated. A print area must have the name Print_Area. 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 print area named range variable is inserted into a Word object.

To create a print area named range variable in an Excel object:

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 variable.
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 variable. 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. Enter a unique name for the print area named range variable.
8. Save your changes in the source Excel object.
9. Click the Default View Mode icon in the status bar.
10. Save your changes to the report and check in the source Excel object.

You can now use the print area named range variable in a Word object to import the information in that range into a worksheet.