Adding logo and picture using ods excel

[LRN]

Hi Everyone,

Good Mornig.

Could some one help me with adding logos and pictures within excel report using ods excel.

Thanks

[Reeza]

Have you tried the preimage option in proc report?

For example this would work in HTML:

ods html file="C:\_localdata\test.html" style=meadow;

proc report data=sashelp.class nowd style(report)=[preimage="http://www.aceds.org/wp-content/uploads/2014/07/six_sigma.jpg"];

title "";

column name age sex weight height;

run;

ods html close;

[LRN]

Hi Reeza, It works with html. But I am working with multisheet excel sheet which has the company logo and a picture. Since, it is not possible with ods excel tagset, trying to see if ods excel would be a better option.

[Reeza]

So if you replace ODS HTML with ODS Excel what happens?

[LRN]

The pic is not getting printed in the excwel sheet

[Reeza]

Check the header? Also, post this in the ODS reporting forum rather than general - you'll get more responses that way.