create xml file

R

Raymond Chiu

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
 
J

Joe Fawcett

Raymond Chiu said:
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
Click to expand...
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.
 
R

Raymond Chiu

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.
 
R

Raymond Chiu

Dear All,

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

Thanks,

Raymond Chiu
 
Top