add logo to excel file from sas 9.4

[sheru]

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.

[Chevell_sas · Accepted solution]

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.