The SAS Output Delivery System and reporting techniques

tagset.excelxp preimage option

Reply
N/A
Posts: 0

tagset.excelxp preimage option

When using the following syntax in my proc report code, the output window displays the logo but not the excel spreadsheet specified in the ods tagsets.excelxp options:


style(report)={preimage="X:\Company_Logo.jpg"}

I also tried invoking the image through a title statement (since I'd like the logo at the top of the worksheet) but that did not work either.

Remedy?
SAS Super FREQ
Posts: 8,869

Re: tagset.excelxp preimage option

Posted in reply to deleted_user
Hi:
By Microsoft design, graphic images are not supported in Excel 2003 XML Spreadsheet Markup Language. Since this is the form of the output written by ODS TAGSETS.EXCELXP (Excel 2003 XML), that means that other ODS destinations, like ODS HTML, ODS RTF, ODS PDF will show preimage graphics, but ODS TAGSETS.EXCELXP output will not use the PREIMAGE file. In fact, if you had tried PROC GPLOT, inside your TAGSETS.EXCELXP "sandwich", then you would have seen this note in the SAS log:
[pre]

Excel XML does not support output from Proc:Gplot
Output will not be created.

[/pre]

cynthia
N/A
Posts: 0

Re: tagset.excelxp preimage option

Posted in reply to Cynthia_sas
Perhaps in the next sas release the preimage syntax can generate a similar warning so I don't waste 4 hours scouring around google for an answer.
Ask a Question
Discussion stats
  • 2 replies
  • 435 views
  • 0 likes
  • 2 in conversation