M
Mahesh
Subject : Automating the XML Data Mapping in Excel 2003
Issue: I am trying to get the XML data out from a XLS file. These are the
steps I am doing right now…
Opened the XLS file and mapped the schema to the xls file using XMAP object
Called the file as SAVEXMLDATA method using the Microsoft Excel Object
library 11.0 Interop dll.
It throwed an exception saying this file cannot be exportable
I checked the IS Exportable property it returned false.
If I drag and drop the individual column from the schema to the Excel
column, it's saves as a XML data.
How to achieve the above step programmatically using C#, I checked an MSDN
article
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlov.asp
it's written in VBA. Some of the objects are not supported in .NET.
Please let me know what is the workaround.
Issue: I am trying to get the XML data out from a XLS file. These are the
steps I am doing right now…
Opened the XLS file and mapped the schema to the xls file using XMAP object
Called the file as SAVEXMLDATA method using the Microsoft Excel Object
library 11.0 Interop dll.
It throwed an exception saying this file cannot be exportable
I checked the IS Exportable property it returned false.
If I drag and drop the individual column from the schema to the Excel
column, it's saves as a XML data.
How to achieve the above step programmatically using C#, I checked an MSDN
article
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlov.asp
it's written in VBA. Some of the objects are not supported in .NET.
Please let me know what is the workaround.