Hi,
I'm looking for some documentation on how to customize the font, color, and other attributes of the index page when using tagsets.excelxp and index='yes'.
Currently, this is the output generated...
...and below is what I am trying to achieve. I want to emphasize to the user that the index is a set of clickable links.
Any insight would be appreciated in this matter.
Thanks,
Mike
It is in your style somewhere. When you start ods do:
ods tagsets.excelxp file="abc.xls" style=statistical options(index="yes");
...
Now your style will define the fonts/sizes etc. Here is an example from SasWeb (which has these links in blue and Helvetica:
style fonts /
'TitleFont2' = ("<sans-serif>, Helvetica, sans-serif",2,bold italic)
'TitleFont' = ("<sans-serif>, Helvetica, sans-serif",4,bold)
'StrongFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold)
'EmphasisFont' = ("<sans-serif>, Helvetica, sans-serif",2,italic)
'FixedEmphasisFont' = ("<monospace>, Courier, monospace",2,italic)
'FixedStrongFont' = ("<monospace>, Courier, monospace",2,bold)
'FixedHeadingFont' = ("<monospace>, Courier, monospace",2)
'BatchFixedFont' = ("SAS Monospace, <monospace>, Courier, monospace",
2)
'FixedFont' = ("<monospace>, Courier, monospace",2)
'headingEmphasisFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold
italic)
'headingFont' = ("<sans-serif>, Helvetica, sans-serif",2,bold)
'docFont' = ("<sans-serif>, Helvetica, sans-serif",2);
You would need to change one of these to be your font (I don't know off hand which one, but any of the above with Helvetica. To change color, then replace the colors section in your template.
Ok. I figured it would come down to manipulating styles and templates, but was hoping there was something simpler to modify only the index page and not the rest of the output. Thank you for the assistance.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.