Month: December 2011

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