Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Automating the XML Data Mapping in Excel 2003 using C#

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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating a worksheet in Excel 2003 hankb Excel Worksheet Functions 2 March 22nd 10 09:09 PM
What version of Excel 2003 do I need to do XML mapping? lmb5111 Excel Discussion (Misc queries) 2 November 8th 06 09:15 PM
Automating Formulas in Excel 2003? Amy Kelley Excel Discussion (Misc queries) 1 December 28th 05 06:42 PM
Automating Excel w VB.Net 2003 [email protected] Excel Discussion (Misc queries) 0 September 23rd 05 05:37 AM
Excel 2003 VBA Help not working when automating via VB 6 Howard Kaikow Excel Programming 6 November 27th 03 03:39 AM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"