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

RE: Re: Excel sheet

• To: "Jonathan Robie" <jonathan.robie@d...>
• Subject: RE: Re: Excel sheet
• From: "Michael Champion" <michael.champion@h...>
• Date: Fri, 20 Jan 2006 14:44:54 -0800
• Cc: <xml-dev@l...>

An API in what library? I suppose one could write a custom XmlReader (the Microsoft pull-model XML API) that would process an Excel binary and could be plugged into a DOM builder to get representation of the spreadsheet as  if it were XML.  I've never heard of such a thing, and anyway the Right Thing is to move Excel's native format to XML by default (which will happen in the next release, in case the original poster wasn't aware of that).

For the time being easiest thing to do would be to load the spreadsheet into Excel (or OO.o, or Corel, or whatever other products support both Excel binary format and XML) and save it as XML. 

> Date: Fri, 20 Jan 2006 17:15:43 -0500
> From: jonathan.robie@d...
> To: michael.champion@h...
> CC: SMir@W...; xml-dev@l...
> Subject: Re: Excel sheet
>
> Michael Champion wrote:
>
>> 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
>>
>
> Hi Mike - suppose I want to access an Excel spreadsheet as XML in a
> program, without loading Excel. Is there an API I could use for this? An
> API that would let me save an Excel spreadsheet as XML would be all I need.
>
> Jonathan
>
> --
> Read my Blog: http://blogs.datadirect.com/jonathan_robie/
> Learn XQuery: http://media.datadirect.com/download/docs/ddxquery/tutorial_query.html
> Learn XQJ (the JDBC for XQuery): http://www.datadirect.com/developer/xquery/topics/xqj_tutorial/
> Get DataDirect XQuery: http://www.datadirect.com/products/xquery/
>
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org , an
> initiative of OASIS
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager:
>

• Prev by Date: Re: Excel sheet
• Next by Date: RE: Re: Excel sheet
• Previous by thread: Re: Excel sheet
• Next by thread: RE: Re: Excel sheet
• Index(es):
  • Date
  • Thread