Re: Is there a tool that converts a plain vanilla XML document into an Excel document?
Stephen D Green <[email protected]>
| Newsgroups | gmane.text.xml.devel |
|---|---|
| Message-ID | <CAA0AChVVs5SumFfuv-7Rd01Dymc0L2115ygGBOa7zckWW72kSw@mail.gmail.com> |
A patented one? https://patents.google.com/patent/CN101968783B/en ---- Stephen D Green On Thu, 4 Aug 2022 at 15:59, Roger L Costello <[email protected]> wrote: > > Hi Folks, > > I have a plain, vanilla XML document with a root element that contains a bunch of <row> elements and each <row> element contains fields, e.g., > > <document> > <row> > <field1>ABC</field1> > <field2>DEF</field2> > <field3>GHI</field3> > </row> > ... > </document> > > To display that XML document in Excel requires a bunch of steps: > > 1. Click on the Developer tab > 2. Click on the Source icon > 3. Click on the XML Maps button > 4. Click on the Add button > 5. Navigate to the folder containing the XML document > 6. Click on the XML document > 7. Click on the OK button > 8. Drag "row" over to the Excel cell > 9. Click on the Developer tab again > 10. Click on Import > 11. Select the XML document again > > Phew! That's a lot of work to get Excel to display the XML document. > > Is there a tool that takes a plain, vanilla XML document and converts it into an Excel document? > > /Roger > > _______________________________________________________________________ > > XML-DEV is a publicly archived, unmoderated list hosted by OASIS > to support XML implementation and development. To minimize > spam in the archives, you must subscribe before posting. > > [Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/ > Or unsubscribe: [email protected] > subscribe: [email protected] > List archive: http://lists.xml.org/archives/xml-dev/ > List Guidelines: http://www.oasis-open.org/maillists/guidelines.php > _______________________________________________________________________ XML-DEV is a publicly archived, unmoderated list hosted by OASIS to support XML implementation and development. To minimize spam in the archives, you must subscribe before posting. [Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/ Or unsubscribe: [email protected] subscribe: [email protected] List archive: http://lists.xml.org/archives/xml-dev/ List Guidelines: http://www.oasis-open.org/maillists/guidelines.php