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 <firstname.lastname@example.org> 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.