[
Lists Home |
Date Index |
Thread Index
]
You can write a transformation script (usually XSLT but any transformation
language will work) to convert the Excel XML to the target schema.
Vice-versa you can convert your XML to Excel XML Spreadsheet format using
XSLT. Both of these will require a knowledge of XSLT and the Excel XML
format.
I have found the easiest way is to do an initial map of my information
into Excel, get the formatting the correct in Excel, then export the
Excel file to XML and use this file as a template for developing my
XSLT conversion. It works pretty well. There are some nuances to the
Excel format that aren't quickly apparent.
Hope this helps!
Betty
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Betty Harvey | Phone: 410-787-9200 FAX: 9830
Electronic Commerce Connection, Inc. |
harvey@eccnet.com | Washington,DC XML Users Grp
URL: http://www.eccnet.com | http://www.eccnet.com/xmlug
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
>
>
>
>
>> To: xml-dev@lists.xml.org> From: SMir@Wockhardtin.com> Date: Fri, 20 Jan
>> 2006 20:18:27 +0530> Subject: [xml-dev] Excel sheet> > > How can i
>> convert the excel sheet into the xml. Because excel sheet contain> the
>> number of page into it. And how i can covert similar converted XML>
>> sheet to excel file.> Regatds
>
> The Office 2003 version of Excel has extensive XML capabilities -- you can
> save spreadsheets in a default XML schema and load custom XML
> schema-defined XML into Excel. See
> http://support.microsoft.com/kb/835298
> http://www.microsoft.com/office/xml/default.mspx
> and you might find the book http://www.oreilly.com/catalog/officexml/
> helpful.
>
> For pre-2003 versions of Excel, see
> http://www.xml.com/pub/a/2002/01/09/q-and-a.html
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
|
