[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Excel sheet

• To: smir@w..., xml-dev@l...
• Subject: RE: Excel sheet
• From: harvey <harvey@e...>
• Date: Fri, 20 Jan 2006 13:10:30 -0500 (EST)
• Importance: Normal
• In-reply-to: <BAY114-W1AA3483A56190105E7C81991F0@p...>
• References: <BAY114-W1AA3483A56190105E7C81991F0@p...>
• User-agent: SquirrelMail/1.4.6 [CVS]-0.cvs20050812.1.fc3

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@e...                    | Washington,DC XML Users Grp
URL:  http://www.eccnet.com          | http://www.eccnet.com/xmlug
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

>
>
>
>
>> To: xml-dev@l...> From: SMir@W...> Date: Fri, 20 Jan
>> 2006 20:18:27 +0530> Subject:  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/

• References:
  • RE: Excel sheet
    • From: "Michael Champion" <michael.champion@h...>

• Prev by Date: Re: Excel sheet
• Next by Date: Re: Utilizing the Web's Whole Information Space, i.e.,Mechanisms/Patterns of Information Usage and Formation?
• Previous by thread: RE: Excel sheet
• Next by thread: Re: Excel sheet
• Index(es):
  • Date
  • Thread