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
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.
On Mon, Jun 1, 2009 at 3:43 PM, Abc Unha <email@example.com> wrote:
> 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.