Date:         Tue, 29 Nov 2011 10:49:50 -0500
Reply-To:     Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Subject:      Re: Is there any way I can insert a logo into the .xls file?
Comments: To: SAS Analyst <analystprasad@yahoo.co.in>
In-Reply-To:  <201111290630.pAT1N3lW008328@waikiki.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Hi Prasad,

You can use ODS HTML and create a .xls file with a logo. I'm sure there are
better ways. May be you can explore excelxp tagsets or some other methods
that are more sophisticated.

Here is the code. On my computer, when i ran the code, a dialog box opened
saying that the file is corrupted or in a different format. I saved it in
.xls format any way and opened it. It preserved the logo.

Good luck.


title1 "<A><IMG align='Left' SRC='
http://www.sas.com/images/logos/SAS_TPTK_logo.gif'></a>";

title2 " ";

title3 " ";

ods html file='test.xls';
*

proc* *print* data=sashelp.class;
*

run*;

ods html close;


On Tue, Nov 29, 2011 at 1:30 AM, SAS Analyst <analystprasad@yahoo.co.in>wrote:

> Hi,
> Is there any way I can insert a logo into the .xls file?
> I've attempted to use the preimage/postimage functions,
> but excel is unable to load my .xls file once it is created with a
> preimage.
> Please do needful
>
> Regards,
> Prasad
>