XML Mapping

[jen_designs]

I have an excel document that I would like to export to xml. I have
been able to create a schema and map each column in excel to the
proper xml node. The question I am having is, instead of mapping to
columns, is there a way to map individual cells? Or even specific
text within a cell?

 

[Chip Pearson]

I have some code on my web site that will create an XML file containing cell
values and information. The hierarchy in the schema is

Areas -> Area -> Cells -> Cell == Address, SheetName, Value, Displayed
Value, Number Format.

Download the schema and the workbook that creates the DOM and saves the XML
file in the zip file

http://www.cpearson.com/Zips/ExceTtoXML.zip

You can probably modify the schema and VBA code to meet your needs.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

This link doesn't work for me... do you have another link to this file?
Thanks in advance for your assistance!!

 

[Guest]

Nevermind, I just realized that "Excel" was misspelled in his link. When I
corrected this, I was able to download it. Thanks!