Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/de...l/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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automating a worksheet in Excel 2003 | Excel Worksheet Functions | |||
What version of Excel 2003 do I need to do XML mapping? | Excel Discussion (Misc queries) | |||
Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
Automating Excel w VB.Net 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 VBA Help not working when automating via VB 6 | Excel Programming |