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

RE: To conver XML to EXCEL

• From: "Hanson, Jon" <jhanson@l...>
• To: 'RAVI KHATAWKAR' <ravi_mk@h...>
• Date: Wed, 17 Oct 2001 15:35:11 +0100

you can either generate a csv (comma separated values) file and import that
into excel, or write a com automation client which progammatically creates
an excel document and then writes the data directly into the worksheet
cells.

the former is simply a case of creating a .csv file looking something like:-

apple,20Sep2001,3.141592
banana,1Apr2001,2.7
pear,,6.9

etc. this will obviously only work if your xml data is of this form, i.e.
one or more tables.

the latter requires understanding of the excel automation object model. it
would be a lot easier to implement in VB if you have that option. you can
use the microsoft msxml parser from VB to read your document.

a third option might be to generate a html table representation of the data
and import that into excel, though i've never tried it.

jon


-----Original Message-----
From: RAVI KHATAWKAR [mailto:ravi_mk@h...]
Sent: 17 October 2001 14:55
To: xml-dev@l...
Subject:  To conver XML to EXCEL


Hi,
   I want to convert XML file to Excel file programmitally. Can anybody help

me on this

Thanks in advance

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this elist use the subscription
manager: <http://lists.xml.org/ob/adm.pl>


------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the designated recipient(s) named above.  If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited.  This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers.  Email transmission cannot be guaranteed to be secure or error-free.  Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such.  All information is subject to change without notice.

• Prev by Date: RE: To conver XML to EXCEL
• Next by Date: Re: To conver XML to EXCEL
• Previous by thread: RE: To conver XML to EXCEL
• Next by thread: XML Database Decision Tree?
• Index(es):
  • Date
  • Thread