Date:         Mon, 1 Jun 2009 15:49:27 -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: ExcelXP tag question about XML to XLS
Comments: To: Abc Unha <abcunha@yahoo.com>
In-Reply-To:  <200906012043.n51HV64n018960@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

You can write a relatively simple script in various scripting languages
(vbs, for example) that briefly opens excel, opens the file, saves it as
.xls, and closes it... I think DATA _NULL_ has posted similar scripts if not
that exact thing in the past.

I don't think you can directly save an excel binary [true .xls] file through
excel tagsets, though.  XML or else use proc export.

-Joe

On Mon, Jun 1, 2009 at 3:43 PM, Abc Unha <abcunha@yahoo.com> wrote:

> Hi,
> I am using ExcelXp because I have multitab/multi workshhet report.
> ExcelXp creates XML file eventhough we specify .xls exentsion. Is there
> anyway SAS can creates actual xls files instead of XML file?
>
>
> The reason I ask because XML file becomes very large and it does not work
> if we are putting on the portal.
> Everytime We have to open it and save as XLS to make it work but we wants
> to make automize this process instead someone menaully open ExceXP file
> and save as XLS.
>
> Is there anyway to create actual XLS files directly from SAS.
>