If I have a OpenXML spreadsheet document with XML mappings, is there a function or a easy way to programmatically export to XML with OpenXML. Similar to the ExportXml function in the Microsoft.Office.Interop.Excel?
Hi,
There is no function to do this in the Open XML SDK. In addition, this functionality is not part of PowerTools for Open XML. However, depending on what you want, this is not too difficult to write.
Take a look at Screen-cast: Using Open XML Spreadsheets as a Data Source.
Here is a screen-cast that shows how to query spreadsheetml using LINQ.
-Eric
Hi Eric,
Thanks for the links Eric. I looked at the screen cast of how to convert Excel sheet to HTML but I have a scenario where there are no tables or table headers in the spreadsheet and instead it is only made of lines, text boxes and other such elements. How can I convert the spreadsheet like that to HTML?