Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Get out clean XML data
I would like to get data out of Excel and into an XML document.
How do I go about setting up Excel so that, for example, cell A5 will be exported as <Employee NameValue of cell A5</Employee Name and cell A6 will be <Date4/15/05</Date etc etc. |
#2
|
|||
|
|||
I think you'll have to write some VBA to do that, or use XSLT. I don't
know how XL could know that A5 was an Employee Name. In article , "Diane" wrote: I would like to get data out of Excel and into an XML document. How do I go about setting up Excel so that, for example, cell A5 will be exported as <Employee NameValue of cell A5</Employee Name and cell A6 will be <Date4/15/05</Date etc etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |