View Single Post
Old 04-20-2022, 05:58 PM   #27
joefromchicago
Hall Of Famer
 
joefromchicago's Avatar
 
Join Date: Jun 2011
Posts: 3,695
Quote:
Originally Posted by pilight View Post
In Excel you'll need to create an xml schema, map every element from the xml file onto it, and hope like hell you don't run into any abstract elements, substitution groups, mixed content, recursive structures more than one level deep, or any other complications Excel can't deal with. Excel can infer the schema from the xml file structure but it doesn't do so very well. I've rarely had an inferred schema turn out right.
You sound like you know way more about Excel than I do

I still have the second part of the tutorial left to do. I may have to reach out to you for advice.
joefromchicago is offline   Reply With Quote