OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   RE: Re: [xml-dev] Excel sheet

[ Lists Home | Date Index | Thread Index ]

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@datadirect.com
> To: michael.champion@hotmail.com
> CC: SMir@Wockhardtin.com; xml-dev@lists.xml.org
> Subject: Re: [xml-dev] 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:

Express yourself instantly with MSN Messenger! MSN Messenger


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS