create xml file

  • Thread starter Thread starter Raymond Chiu
  • Start date Start date
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
 
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.
 
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.
 
Dear All,

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

Thanks,

Raymond Chiu
 
Back
Top