I have an existing project using Excel 2003 that has XML mapping to cells in the worksheets. To export and import the mapped data I had to automate Excel and call the ExportXML/ImportXML methods for Excel.

I am now rewriting this project to use OpenXML so that I will not have to automate Excel on the server but I am having trouble finding a similar method for exporting/importing data from my XML maps.

If someone can point me in the right direction that would be great. What I need to do appeared to be basic but I think I am doing the wrong searches.

Thanks,

Richard