E
Ed from AZ
(Windows XP Pro, Office 2003) I work with a Java-based program that
creates an XML file. Sometimes information needs to be transferred
between XML docs. At the moment, I can open an XML in Word, and copy
and paste between the XMLs.
Some of the data, though, would lend itself very well to an Excel
spreadsheet. When I try to open an XML file with Excel (either by
right-clck on the XML file and Open With or XL >> Data >> XML >>
Import), Excel creates a schema that doesn't present the information
in a way I can logically work with it.
The Java program consists of forms to fill out, and some of them are
repeating, or child, forms. This is the data that I am most
interested it - seeing all the data for each of the child forms in a
group where I can edit, add, delete, etc as I wish.
Where do I go to learn what I need to about working with XML in Excel
2003?
Thanks.
Ed
creates an XML file. Sometimes information needs to be transferred
between XML docs. At the moment, I can open an XML in Word, and copy
and paste between the XMLs.
Some of the data, though, would lend itself very well to an Excel
spreadsheet. When I try to open an XML file with Excel (either by
right-clck on the XML file and Open With or XL >> Data >> XML >>
Import), Excel creates a schema that doesn't present the information
in a way I can logically work with it.
The Java program consists of forms to fill out, and some of them are
repeating, or child, forms. This is the data that I am most
interested it - seeing all the data for each of the child forms in a
group where I can edit, add, delete, etc as I wish.
Where do I go to learn what I need to about working with XML in Excel
2003?
Thanks.
Ed