Hello,

Could you tell me how to map element of xml as list of list in Excel or Calc.


examples, list of customers and list of items. 1 customer bought many items.

As I know about list of list, http://support.microsoft.com/kb/840474, XML schema constructs that are not supported by Excel 2003.
I am not sure it is fixed by Excel 2007 or Excel 2010 or not yet.

Also welcome any idea or new free simple tool that provide as GUI of table and then generate in XML data file.

Thanks.

Download this addin for office 2007 at http://www.microsoft.com/download/en...ang=en&id=3108

after this, you can create an xml schema after data in a table as explained here: http://office.microsoft.com/en-us/ex...010263509.aspx

let us know if you need more...