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

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

DMoovendhan — Tue, 31 Oct 2017 11:16:26 GMT

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

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

Reeza — Tue, 31 Oct 2017 15:00:17 GMT

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

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

DMoovendhan — Tue, 31 Oct 2017 17:38:57 GMT

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.

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

Reeza — Tue, 31 Oct 2017 17:42:13 GMT

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.

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

Vince_SAS — Tue, 31 Oct 2017 23:05:08 GMT

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

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

Reeza — Wed, 01 Nov 2017 00:01:59 GMT

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

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

DMoovendhan — Thu, 02 Nov 2017 17:45:01 GMT

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

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

DMoovendhan — Tue, 07 Nov 2017 09:41:07 GMT

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.