Category: XML

Using XSL Variable and Axes to format XML data into HTML having elements grouped by a tag

Using XSL Variable and Axes to format XML data into HTML having elements grouped by a tag

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…

Read More Read More

Excel Add-in for Exporting data to XML

Excel Add-in for Exporting data to XML

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…

Read More Read More

Writing Add-in for Microsoft Excel 2010 using Visual Studio 2010

Writing Add-in for Microsoft Excel 2010 using Visual Studio 2010

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,…

Read More Read More

Loading and Saving a TreeView control to an XML file using XmlTextWriter and XmlTextReader

Loading and Saving a TreeView control to an XML file using XmlTextWriter and XmlTextReader

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.