Date: Mon, 5 Oct 2009 07:50:19 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: Bare Bones Excel Tagset?
Content-Type: text/plain; charset=ISO-8859-1
The style template that is used will apply (or not apply) formatting. You
can override nearly all of the formatting elements that way. Look at the
documentation for PROC TEMPLATE for more details.
On Mon, Oct 5, 2009 at 6:48 AM, Vandenbroucke, David A <
> Is there an Excel tagset that doesn't do any formatting? All of the ones
> I've tried do a lot with shading, borders, special fonts, etc. I certainly
> understand how those things can be useful. However, most of the time what I
> want to do is just put, say, PROC REPORT output into an Excel file, where I
> or others might well want to manipulate the data and presentation further.
> At present, my first task is usually to remove all the formatting that ODS
> puts into the spreadsheet. Is there some kind of vanilla tagset that will
> save me this work?
> Dav Vandenbroucke
> Senior Economist
> U.S. Dept. HUD
> I disclaim any disclaimers.