Date:         Wed, 8 Dec 2004 09:35:16 -0500
Reply-To:     "Gerstle, John" <YZG9@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Gerstle, John" <YZG9@CDC.GOV>
Subject:      Re: ODS Excel Output and Stylesheet
Comments: To: "James, Steve" <SPJ1@CDC.GOV>
Content-Type: text/plain; charset="us-ascii"

I recognize some of that problem.  When using ODS HTML to create Excel
spreadsheets, Excel doesn't always save the file as an Excel file. It
may save it as a set of HTML files, located in the folder with the
original spreadsheet. Of course, if you send the spreadsheet without the
folder of HTML files, the spreadsheet can't find them.  I'm not sure why
this problem doesn't happen every time I create a set of files in this
way (or maybe it does and it 'fixes' itself to save the file as an Excel
file), but I've had to Save As and make the file an Excel file and not
HTML.

John Gerstle
CDC Information Technological Support Contract (CITS)
Biostatistician


>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>> James, Steve
>> Sent: Tuesday, December 07, 2004 6:00 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: ODS Excel Output and Stylesheet
>>
>> SAS-L,
>>
>> I'm using SAS 9.0 on a Unix platform, and am using SAS/IntrNet to
create
>> Excel files from a web application that I've created.  Since we're
not
>> able
>> to place the application outside the firewall yet, CDC staff have
been
>> running reports for our partners outside of CDC and distributing them
via
>> email.  I'm using a cascading-style sheet when generating the output,
>> however the style information does not get carried along with the
>> spreadsheet.  When someone outside the CDC tries to open a file
generated
>> in this manner, they get an error that the cascading-style sheet
cannot
>> be
>> found.
>>
>> How can I get the Excel spreadsheet to have the characteristics that
I
>> want
>> while it remains independent enough not to have to link back to the
>> stylesheet that's on the server inside the firewall? Is there a way
to
>> embedd the stylesheet into the Excel file?  Alternatively, is there a
way
>> to remove the link back to the stylesheet so that if I can't get it
look
>> the right way I can at least get it to stop telling me it can't find
the
>> stylesheet?
>>
>> Here's the code I'm currently using:
>>
>> ods html body=_webout (title='ASSESSMENT Branch Sampling') rs=none
>>
stylesheet=(url='http://fnip-xdv-sun1.nip.cdc.gov/spj1/school04.css') ;
>>
>>
>> I'd appreciate any help that you can give me.
>>
>> Sincerely,
>>
>> Steve James
>> Centers for Disease Control and Prevention
>> sjames@cdc.gov