Feasibility of XML import with complex data for Excel

Wish I could do it that way. Problem is there exists a report already that I am basing the new one on for another product line. And there are more than 1 section(table) on a page. Plus the XML will actually have many unused items for the report that won't be included. Different sections have items that are in different locations in the XML file and not relative to each other. So would need a way to identify what goes where, and can appear on more than 1 page or section. The deeper I go in the existing code and data, the less likely there are tools that would be beneficial. Have considered XSLT transform into a workable format but that is getting too complex since even the resulting data would need to be interpreted. Or doing a deeper dive into the XSD import schema. Or putting fields in a XLT template with either formulas or VBA as needed to manipulate data and combine item data as needed. But Don't see an easy mapping to the XML file items and relations. If Xpath or something like that is an option from Excel, then it would get too long and cumbersome with the filtering to identify an item, get the value, and map it to a text string for display.
Pretty sure I am abandoning the idea and sticking with C# and Excel automation. With possible DB data mapping and some configuration options in a config file. Things I need to do would get a bit outside of VBAs design as far as I can see. Plus I do have some existing tools I made which I can reuse for part of what I need to do in C#.
Thanx for the response either way.