ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import External Data - XML (https://www.excelbanter.com/excel-discussion-misc-queries/52370-import-external-data-xml.html)

mklapp

Import External Data - XML
 
Hello,

I have been using an application that generates an XML File along with a
schema. This file is then imported into Excel for further processing.
Typically, this loads several rows (as many as there are columns) of
metadata. Following these rows, offset by the number of columns of metadata,
are the rows of data.

If only one record is contained in the XML file, this record appears
repeatedly next to each row of metadata.

I do not need a fix for this. I am sharing it because it is something
that should be shared.


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com