XML Mapping
 

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?

XML Mapping
 

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)



wrote in message
oups.com...
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?

XML Mapping
 

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


"Chip Pearson" wrote:

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)



wrote in message
oups.com...
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?

XML Mapping
 

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

"Allen Geddes" wrote:

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


"Chip Pearson" wrote:

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)



wrote in message
oups.com...
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?