Using XmlImport/Export Fucntions for excel

U

Umair Hasan

All the functions for importing/exporting xml from/into an excel sheet that
have an "out" variable as an argument are throwing COM exceptions.

for example:
Globals.ThisWorkbook.XmlImport(("F:\\temp\\aa.xml"), out map, missing,
missing) is not working but
map.Import("F:\\temp\\aa-2.xml", missing) is working

Similarly:
map.ExportXml(out xmlString) is not working but
map.Export("F:\\temp\\result.xml", overwrite) is working

Here is the exception: {"Type mismatch. (Exception from HRESULT: 0x80020005
(DISP_E_TYPEMISMATCH))"}

any thoughts??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using find in excel from C# code 0
Calling excel function using C# 1
XmlImport Problem in Excel 2007 0
OWC11 pivot table export to excel fail: missing tag row (seems to 0
Add-in: type mismatch COM exception while accessing Excel 2003 3
Problems using SaveAs and SaveCopyAs 0
Using SQL command to access Excel 4
Excel Addin using SaveAs Function 2

Top