BookmarkSubscribeRSS Feed
mansour_ibrahim
Obsidian | Level 7

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

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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?

Cynthia_sas
SAS Super FREQ
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-paren... and https://communities.sas.com/t5/SAS-Procedures/proc-template-warnings-could-not-not-restore-reference... might be relevant.

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

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 730 views
  • 0 likes
  • 3 in conversation