ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute With the ExcelXP Tagset

The ODS ExcelXP tagset has many options to change its behavior. Many are set with the options in the ODS statement. There are others that must be set through the style. Most of these are set in the TAGATTR= style attribute, an unused, leftover attribute from SAS Release 7.01. This paper will show how to use the TAGATTR= style attribute to control the ExcelXP tagset in order to change the type, format, formula rotation, hiding, merging, and wrapping of cells, rows, and columns. This paper will also go behind the scenes to show how the tagset handles these settings and manages the problems presented by the XML that the tagset must create.

Provided by: SAS Institute Topic: Software Date Added: Mar 2010 Format: PDF

Find By Topic