Adding logo and picture using ods excel

Reply
Contributor LRN
Contributor
Posts: 57

Adding logo and picture using ods excel


Hi Everyone,

Good Mornig.

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

Thanks

Super User
Posts: 19,051

Re: Adding logo and picture using ods excel

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;

Contributor LRN
Contributor
Posts: 57

Re: Adding logo and picture using ods excel

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.

Super User
Posts: 19,051

Re: Adding logo and picture using ods excel

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

Contributor LRN
Contributor
Posts: 57

Re: Adding logo and picture using ods excel

The pic is not getting printed in the excwel sheet

Super User
Posts: 19,051

Re: Adding logo and picture using ods excel

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

Ask a Question
Discussion stats
  • 5 replies
  • 387 views
  • 0 likes
  • 2 in conversation