The SAS Output Delivery System and reporting techniques

ODS EXCEL to have multiple tabs and embed image(logo) in title

Reply
Contributor
Posts: 65

ODS EXCEL to have multiple tabs and embed image(logo) in title

HI,

 

I am using the below code to create multiple sheets of excel output.

But I am not able to get the image embed into the title.

 

 

ods tagsets.excelxp file = "&excelpath" style =printer
options(sheet_name = 'Cover Page' sheet_interval='proc' embedded_titles='yes');
ods escapechar='~';

Title5 justify=left bold "Study :" notbold "study name" '~S={postimage="/tlly2t/3rdparty/irserver/lilly.png" color=white} y';

/*--- sas statements ---*/

 

Ods options(sheet_name = 'parameters' sheet_interval='proc' embedded_titles='yes');

Title5 justify=left bold "Study :" notbold "study name" '~S={postimage="/tlly2t/3rdparty/irserver/lilly.png" color=white} y';

/*--- sas statements ---*/

 

ods _all_ close;

 

I have attached the screen shot of the sample requirement heading to this query.

Kindly help.

 

Regards,

Moovendhan Devaraj

Attachment
Super User
Posts: 22,818

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

Posted in reply to DMoovendhan

ODS TAGSETS does not support embedded images. Your code is not ODS EXCE, but ODS EXCEL does support multiple tabs/embedded images. However, it's not production until SAS 9.4 TS1M3

 

 

Contributor
Posts: 65

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

Thanks Reeza for looking into this.

 

I am using sas 9.4, and I am able to create multiple tabs with it, should I modify the code to get the image embedded.

Previously with tagset I was getting a link added to the excel but now not getting any of the info in output.

 

Please advise.

Super User
Posts: 22,818

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

Posted in reply to DMoovendhan
Post the code your actually using then. There's a paper from Chevell Parker on lexjansen.com that has examples of how to embed images.
SAS Super FREQ
Posts: 343

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

I don't think that the Excel destination supports PREIMAGE, either:

 

ods _all_ close;

ods escapechar='^';

*  Embed a JPG file;

title "^{style [preimage='path-to-image-file\image-file-name.jpg']}";

ods html  file='path-to-output-file\temp.htm';
ods pdf   file='path-to-output-file\temp.pdf';
ods Excel file='path-to-output-file\temp.xlsx';

proc print data=sashelp.class(obs=1); run; quit;

ods _all_ close;

 

The image is embedded in HTML and PDF, but not Excel.

 

Vince DelGobbo

SAS R&D

Super User
Posts: 22,818

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

 No, preimage isn’t supported but other methods are available. See the example starting on page 3 here

https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

Contributor
Posts: 65

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

Thanks Reeza, this paper looks interesting, let me check it and will get back to you, thanks.

Contributor
Posts: 65

Re: ODS EXCEL to have multiple tabs and embed image(logo) in title

I tried it, 

 

But the code that I am executing is in Unix and I couldn't execute the .vbs file.

 

I am dropping an email to support@sas.com.

Please let know if you have any other thoughts.

Ask a Question
Discussion stats
  • 7 replies
  • 512 views
  • 0 likes
  • 3 in conversation