Following XSL converts the xml data into a format where first tag of the element is converted into heading and all elements having the same value for first tag will appear in a table below that heading. The Xml elements must be sorted by first tag. To understand the transformation, consider the following Xml: The…
Download ExcelExportXML-Setup – 221.11 KB Download ExcelExportXML-Source – 328.11 KB Introduction ExcelExportXML is a Microsoft Excel 2010 Add-in that generates XML data from excel sheet. It is developed in Visual Studio 2010 using C#. It is a very simple add-in. To understand how to works, consider an excel sheet having following data. Country Capital Continent…
Using Visual Studio 2010 Professional, creating Excel Add-in is pretty simple. Following are the steps I followed for writing an Add-In for exporting Xml: Step # 1 Create new project of type ‘Excel 2010 Add-in’. The project will have a class file called ThisAddin.cs. Step # 2 For creating a button on the Excel ribbon,…
Follow the below link to see my article at CodeProject with source code. http://www.codeproject.com/KB/cpp/TreeView_Serializer.aspx It demonstrates how to serialize and de-serialize the contents of System.Windows.Forms.TreeView control from an XML file using forward only, non-cached XmlTextReader and XmlTextWriter.