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>
Organization: http://groups.google.com
Subject:      Re: Convert Excel file created with tagsets.excelxp to xls/xlsx
Comments: To: sas-l@uga.edu
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?
> Thanks,
> Alex

The first thought is to simply use SaviCellsPro and have it do it for
you:

http://www.sascommunity.org/wiki/SaviCellsPro

The original SaviCells may be a better fit but you can determine that:

http://www.sascommunity.org/wiki/SaviCells

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.

Alan
http://www.savian.net