xml maps

I have 3 tables in Excel 2016 worksheet. Tables 1 and 3 are connected to SQL database and Table 2 has a XML Map to import and display XML-files. Created a simple mockup to better illustrate this. When loading data, each autoexpand fine and push header of the table beneath downwards to make...

The exported XML always contains elements for columns mapped to XSD xs:element with minoccurs="0", while there is no data in the cells. I would have expected Excel to not have created the elements at all. More in detail: An XML map is used to map the Excel columns. The XSD contains an...

I built an xml parser with excel. I wrote some vba (with help from this forum) to open a dialogue box to import my xml file. (code below) Currently it loads into a single xml map (Base_CRD_Map), but I want it to load into 6 xml maps all within one workbook and I'd like to know how to write a...

I am having problems trying to "share workbook" every time i do it pops up 'This workbook can not be shared because it contains Excel tables or XML maps. To share this workbook, convert the table ranges and remove the XML maps.' i have converted the tables to range and i have looked into the...

hi everyone, I have two question about determing mapped xml node first: how to determine which xml element is mapped for particular cell (also, in othter way, how to determine for which cell is mapped for some xml element) second: is there a possibility to retrive restrictions for particular...

I have an excel 2007 spreadsheet that exports xml using an xml map. It works fine. It has one row of order info with one row of headers above it. So it has a supplier, buyer, ordernumber, item number, qty, etc. There is only one order of one item. Each header above each output cell has the list...