Excel and XML -- exporting sheets and lists of lists.
Posted on 2004-08-12
My company is using an excel spreadsheet for data capture. The sheet has complex relationships (lists of lists) and multiple tabs of data within the excel file. Excel in Office 2003 has the ability to export data to an .xml file, provided an .xsd is used to create a map. The problem is the (relative) complexity of the data. The first issue is with the excel sheet tabs; can a repeating element be mapped from each tab, where each tab is an instance of that element? The second issue is the mapping of “lists of lists”.
Is it possible to export repeating elements which contain repeating elements? I’ve been unsuccessful so far, though it doesn’t seem like it should be difficult to do. This seems to be a simple matter of being able to nest a child XML element under a parent from the EXCEL sheet, but Excel doesn't seem to be able to do that, at least not from the mapping provided.
Any info would help, thanks!