|Date: ||Wed, 28 Oct 2009 18:19:00 -0700|
|Reply-To: ||Jack Hamilton <jfh@STANFORDALUMNI.ORG>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Jack Hamilton <jfh@STANFORDALUMNI.ORG>|
|Subject: ||Re: Convert Excel file created with tagsets.excelxp to xls/xlsx|
|Content-Type: ||text/plain; charset=us-ascii; format=flowed; delsp=yes|
Why not do it in Excel? It's simple to write a VBA routine that
converts all the XML files in a directory into XLS format.
Caelum non animum mutant qui trans mare currunt.
On Oct 27, 2009, at 2:14 am, Alex 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?