Export Excel data to xml WITHOUT an existing xsd

[DairylandDan]

Hmm, I've got a problem that I can't seem to get around.

The company has an Excel work book with 11 Sheets. There are many functions moving and altering data entered on one sheet to other cells on other sheets. The state DNR supplies a ready built xml document and wants this data imported into the appropriate xml nodes. But, they don't have an xsd. I've tried creating an xsd from the xml document (via the following example:

http://www.mrexcel.com/tip064.shtml)

. . . but, the xsd which is created doesn't work when I try to do the 'export to xml' from within the excel document.

I think it has to do with the 'list of lists' problem.

I'm using Excel 2003 SP3 - Office Professional Edition 2003.

Any suggestions would be greatly appreciated.



DlD

 

[DairylandDan]

Update and slight clarification.

OK, I got the xsd to create successfully.

I open the Excel document. Then do Data/XML/XML Source. Then open up the xsd map in the XML Source pain. Then, when I try to export the data, I get the error: "Cannot save or export XML data. The xml maps in this workbook are not exportable."

The one thing that remains from the original post is the fact that I think this still pertains to that 'list of lists' limitation. And I still don't quite understand how to get around that.


DLD

 

[tsuji]

Ask the question in office forum.

http://tek-tips.com/threadminder.cfm?pid=68