3 ms·
I'd be interested to learn more about this, I've never heard of anyone importing XML into Excel before - typically "flat files" or SQL datasets are imported int
by mistermann 11y ago
I'd be interested to learn more about this, I've never heard of anyone importing XML into Excel before - typically "flat files" or SQL datasets are imported into an Excel table, upon which you can quickly build a pivot table, etc. Are you pulling in nested data?
- 5h 11y agoyes, exactly that, drag an xml file into excel, choose "generate a schema", then you can drag and drop fields from your nested structure, parent records will be repeated intelligently for nested sub-records.
- discordance 11y agoI import nested XML into Excel all the time. You will need to create an XML Map first. Look under Excel/Developer/XML Source/XML Maps