add logo to excel file from sas 9.4

sheru — Fri, 06 Nov 2015 15:09:22 GMT

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-from-sas/

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.

Re: add logo to excel file from sas 9.4

Chevell_sas — Tue, 22 Mar 2016 13:37:31 GMT

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.

topic add logo to excel file from sas 9.4 in ODS and Base Reporting

add logo to excel file from sas 9.4

Re: add logo to excel file from sas 9.4