The SAS Output Delivery System and reporting techniques

add logo to excel file from sas 9.4

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

add logo to excel file from sas 9.4

Hello Guys

i was trying to add logo to an Excel report(multisheet excel file), which is generated using ODS excelsxp and  proc report. from what i read on knowledge base and other sourses. the only way we can acomplish this in SAS 9.2 is by using ODS HTML, like its mentioned in following link: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html.

 

Now we have upgraded our SAS to 9.4, i heard we can accomplish the same task with ODS EXCEL

http://blogs.sas.com/content/sasdummy/2014/08/29/experimenting-with-ods-excel-to-create-spreadsheets...

 

but i dont see any explanation of how this works in ODS EXCEL. can any one help me, understand how this is done in SAS 9.4 using ODS EXCEL.

 


Accepted Solutions
Solution
‎03-22-2016 10:13 AM
SAS Employee
Posts: 88

Re: add logo to excel file from sas 9.4

The current verion of the Excel destination supports adding background images to the worksheet, however, it does not support adding images for individual cells. This would require the that the file be post processed with VBscript or the like to add the images.

View solution in original post


All Replies
Solution
‎03-22-2016 10:13 AM
SAS Employee
Posts: 88

Re: add logo to excel file from sas 9.4

The current verion of the Excel destination supports adding background images to the worksheet, however, it does not support adding images for individual cells. This would require the that the file be post processed with VBscript or the like to add the images.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 613 views
  • 0 likes
  • 2 in conversation