create xml file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raymond Chiu - 03 Nov 2007 11:00 GMT

Dear All,

I want to create xml file through excel.
I only have several attributes names.
How can I do? I am using office 2003 Professional.

Thanks,

Raymond Chiu

Reply to this Message

Joe Fawcett - 03 Nov 2007 11:13 GMT

> Dear All,
>
[quoted text clipped - 5 lines]
>
> Raymond Chiu

I believe you have two basic choices.
You go with Excel's built-in support. Thisw normally invlvges creating an
XML schema to describe your output file, mapping the various nodes to cell
data in your worksheet and then saving the sheet as XML.
The alternative is to used VBA to process the cell data and manually build
up a an XML docuemnt using the DomDocument class. This can then be saved.

Signature

Joe Fawcett (MVP - XML)
http://joe.fawcett.name

Reply to this Message

Raymond Chiu - 04 Nov 2007 13:43 GMT

Dear Joe,

What is the menu options to your choose 1?
Do you have any links to describe how to creating an
XML schema to describe your output file, mapping the various nodes to cell
data in your worksheet and then saving the sheet as XML.

"Joe Fawcett" <joefawcett@newsgroup.nospam> ¼¶¼g©ó¶l¥ó·s»D:%23nizBJgHIHA.4592@TK2MSFTNGP02.phx.gbl...

>> Dear All,
>>
[quoted text clipped - 12 lines]
> The alternative is to used VBA to process the cell data and manually build
> up a an XML docuemnt using the DomDocument class. This can then be saved.

Reply to this Message

Raymond Chiu - 05 Nov 2007 03:19 GMT

Dear All,

Any Help is welcome!!!
Please help on How to do?

Thanks,

Raymond Chiu

"Raymond Chiu" <rchiu2hk@yahoo.com.hk> ¼¶¼g©ó¶l¥ó·s»D:O3g80iuHIHA.4956@TK2MSFTNGP06.phx.gbl...

> Dear Joe,
>
[quoted text clipped - 21 lines]
>> build up a an XML docuemnt using the DomDocument class. This can then be
>> saved.

Reply to this Message

Rate this thread: