LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2011, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 >


Back to: Top of message | Previous page | Main SAS-L page