LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments:   To: Alex <alexander.konn@IEA-DPC.DE>
In-Reply-To:   <20d1f3b9-fe5e-4eaa-bd50-2954cfdffb2c@g27g2000yqn.googlegroups.com>
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.

-- Jack Hamilton jfh@alumni.stanford.org 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? > Thanks, > Alex


Back to: Top of message | Previous page | Main SAS-L page