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:   Tue, 27 Oct 2009 02:14:24 -0700
Reply-To:   Alex <alexander.konn@IEA-DPC.DE>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Alex <alexander.konn@IEA-DPC.DE>
Organization:   http://groups.google.com
Subject:   Convert Excel file created with tagsets.excelxp to xls/xlsx
Comments:   To: sas-l@uga.edu
Content-Type:   text/plain; charset=ISO-8859-1

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
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu