Date: Tue, 27 Oct 2009 22:39:41 -0700
Reply-To: Savian <savian.net@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Savian <savian.net@GMAIL.COM>
Subject: Re: Convert Excel file created with tagsets.excelxp to xls/xlsx
Content-Type: text/plain; charset=ISO-8859-1
On Oct 27, 3:14 am, Alex <alexander.k...@iea-dpc.de> wrote:
> Hi all,
> I have xml files created with ODS tagsets.excelxp and would like to
> convert them from plain xml to xls and/or xlsx. I can open them in
> Excel and Save as..., but need to do it automatically from a SAS
> program. The sheets in the files are not just one rectangular data set
> each, but two or more data sets with different columns. Also the
> sheets contain a lot of formatting. So just importing the xml and
> exporting to xls/xlsx wouldn't work, I guess.
> Any ideas?
The first thought is to simply use SaviCellsPro and have it do it for
The original SaviCells may be a better fit but you can determine that:
The second is that you write something similar to SCP and simply open
and save at a rapid clip. If you go this route, download Visual Studio
Express, create a console app, add in the Office interops, then open
and save the files using Excel. Call everything via a SAS X command.