Exporting Data to Excel in JavaScript

Microsoft Excel is the most popular spreadsheet application used nowadays on all kinds of operating systems and devices. It provides functionality for formulae calculations, graphs and charts, pivot tables, and other great enterprise features.

ShieldUI now provides the ability to export data in two wide-spread Excel file formats - XML and XLSX, which are very flexible and fully-compatible with other spreadsheet software like Apache Open Office, Star Office and etc. The generation of the file content is done solely in the client web browser, without any dependencies on the server-side. By using another recent addition - the file save-as functionality, the ShieldUI framework also delivers the file on the users' local devices, where they can be processed further.

The exporting functionality is built-in in the ShieldUI Grid component, which makes it very easy to be enabled. Using just configuration options, developers can set up the spreadsheet header, the data source to be used for retrieving the rows, individual column options, and etc. For complex scenarios, there are several commands that can be overriden, where custom settings for the general as well specific rows and columns, can be specified.

The Excel export functionality is available for all platforms - JavaScript&HTML5, ASP.NET, ASP.NET MVC and Java Apache Wicket. For more information check the documentation and the live demo sections.