ferebrilliant.blogg.se

Excel import xml data excel generates a table
Excel import xml data excel generates a table







I wanted to take parent/child XML to Excel then back from Excel to parent/child XML. Excel itself is a "flat table" type of database".

excel import xml data excel generates a table

I am giving substantial weight to one of the earlier responses where the respondent said "Excel's XML capabilities do not support parent-child relationships. You can get more information on OpenXML at and the OpenXML SDK forum. You should be able to access the closed file through that and use standard XML tools to extract and recompose the data. Or, if this is Office 2007, you might take a close look at the OpenXML file format. Excel itself is a "flat table" type of database, so that's logical :-) Therefore, if you need your data in a more complex form you will need to do additional, "manual" processing using the object model or ADO.NET (through an OLE DB connection to the closed file). Note that the moderators there are a bit picky, and will only look at a question if it's posed in the "How do I." form.įor other Office versions, please consult the list of links in the " Please Read First" message at the top of the VSTO forum.įWIW, Excel's XML capabilities do not support parent-child relationships.

excel import xml data excel generates a table

If the application version is 2007, the " Innovate on Office" forum is a good place to ask. But general application / object model / interop is not supported. Since the question seems to be related more to MS Excel rather than to Xml itself I would advise to ask it on Visual Studio Tools for Office forum ( ).Īctually, the VSTO forum targets the VSTO technology, with a little bit about Word and Excel where the discussion intersects with document-level customizations.

excel import xml data excel generates a table

Long story short, Excel can't handle 'lists of lists' and how to export data in that way in XML format

excel import xml data excel generates a table

If i map items table to the schema it works.īut when i try to map the customer table, excel can't export the data and gives error 'can't export, data contains list of lists'.Īlso when the data to customer table is mapped to exl schema, excel fails to retain the relationship of items from cutomer table and item table.Īs a result the data can't be exported from excel not being normalized. and excel can't map one cell to more than one element in one xml schema. These items in the customer list comes from the items' table. In the xml schema, items have a list which has been mapped to a specific cells in Excel spreadsheet.Īlso the cutomer part of the schema have been mapped to specific cells.įor customers, information in the xml looks like this I have a schema which contains customers and items he is buying. Please find the example scnario as below:









Excel import xml data excel generates a table