Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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?


I 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


yes, 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: