How can i serialize an Excel charting Object to XML using
XmlSerializer IN .Net?
I tried serializing it ..but comes with an error "Cannot Serialize Interface
Excel.chart"
Let me know how we can do this
Printable View
How can i serialize an Excel charting Object to XML using
XmlSerializer IN .Net?
I tried serializing it ..but comes with an error "Cannot Serialize Interface
Excel.chart"
Let me know how we can do this
Not sure whether you can serialize out of proc. COM object using .NET serializer.
Latest versions of Excel let you save the file in xml format (called SpreadsheetML). Not sure whether it is started with '97 or 2000 version. See whether it helps. Use Excel's built-in macro recorder to get the code to save the sheet/workbook in xml format.