ODS Markup to Excel

mansour_ibrahim — Mon, 24 Apr 2017 09:14:28 GMT

Good morning,

I can't export graphic in excel.

I have this message error

WARNING: Could not restore referenced object: tagsets.htmlcss.
WARNING: Could not find parent template: tagsets.htmlcss.
ERROR: Styles.Default not found. Be sure that Styles.Default and your preferred style are in your ODS path

Can you help me please.

think you

Re: ODS Markup to Excel

RW9 — Mon, 24 Apr 2017 09:40:00 GMT

Can you provide what you are trying to do, e.g. code. Graphic could mean any number of things. Have you tried ods tagsets.excelxp?

Re: ODS Markup to Excel

Cynthia_sas — Mon, 24 Apr 2017 12:49:20 GMT

Hi:
ODS TAGSETS.EXCELXP does not support any graphics by Microsoft design. ODS EXCEL (need 9.4) does support graphics.

ODS HTML, ODS MSOFFICE2K and ODS TAGSETS.MSOFFICE2K_X and other HTML-based destinations would allow you to create an HTML file with text and graphics and then Excel (ever since Excel 97) can open this type of HTML file.

But you need to post ALL your code because you would get a different warning message if TAGSETS.EXCELXP could not create graphics.

And, you don't really "export" graphics from SAS to Excel. For HTML-based destinations, your file has an <IMG> tag that Excel knows how to use (most of the time).

@RW9 is right -- we need to see ALL your code that produced your error message. The message you got seems very similar to these http://support.sas.com/kb/33/356.html and https://communities.sas.com/t5/Base-SAS-Programming/TEMPLATE-restore-reference-object-and-find-parent-template/td-p/309366 and https://communities.sas.com/t5/SAS-Procedures/proc-template-warnings-could-not-not-restore-referenced-object/td-p/214149 might be relevant.

If you are trying to use a custom style template, you need to include that code too.

cynthia

topic Re: ODS Markup to Excel in ODS and Base Reporting

ODS Markup to Excel

Re: ODS Markup to Excel

Re: ODS Markup to Excel