Date:         Fri, 21 Sep 2007 04:26:34 -0700
Reply-To:     "ckxplus@yahoo.com" <ckxplus@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "ckxplus@yahoo.com" <ckxplus@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: ExcelXP query
Comments: To: sas-l@uga.edu
In-Reply-To:  <1190351100.204845.244930@19g2000hsx.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

Hi Regi,

You can start by using "style=minimal" in your "ods tagsets.ExcelXP"
statement. That will eliminate the coloring but there will be lines
between cells. You can elimate those using e.g.

proc print data=sasuser.class noobs label
        style(table) = {borderwidth=0}
        style(data) = {borderwidth=0}
        style(header) = {borderwidth=0}
        ;
run;

It would be better to create a template based on minimal with these
options (not sure if they're all necessary). This gets you a plain
vanilla spreadsheet in the area with data in it but the area outside
that is white with not visible borders between cells. You can probably
fix that with some other style options.

Good luck,
John Hendrickx

On 21 sep, 07:05, rmat <reg...@gmail.com> wrote:
> Hi All,
>
> I use ExcelXP tagset to get all CSV outputs in one XL file. But I am
> not liking the embellishments I get in the standard output. Currently
> I get colored background, bold field names etc. All these are
> unnecessary and I end up spending time to remove it.
>
> Is there any way I can get this output looking just like CSV files?
> Can you please suggest what option I should choose to get this?
>
> Thanks very much, Regi