Exporter is a generic export class which takes any Ext.data.Store-based component (e.g. grids and similar) and exports the data in any format.
Exporter works completely client-side. It uses a Formatter class to generate a document (.xls, .csv etc) and then redirects the user’s browser to a data url so that they can view or download it.
This tutorial will walk through how to export data from ExtJS DataGrid directly to Excel.
Apache have released version 3.5 of POI, the Java library for working with Microsoft's document formats. POI previously supported Microsoft's OLE2 compound document formats as used in Office 97-2003 (versions 8.0 - 11). With POI 3.5 Apache have added support for Microsoft's Office Open XML (OOXML) document standard, the default file format for Microsoft Office 2007.
The Apache POI team is pleased to announce the availability of Apache POI 3.5
beta 5, our latest beta including OOXML (Office Open XML) support.
Microsoft made a stunning announcement during today's Professional Developers Conference: A lightweight Web-based version of Office. Office Web is a stunning concession to Google and other Web 2.0 platform developers offering Web-based productivity applications. Office Web will come with lightweight versions of Word, Excel, PowerPoint and OneNote.
Obba provides a bridge from Excel sheets to Java classes. With Obba, you can easily build Excel GUIs to Java code. Its main features are:
* Loading of arbitrary jar or class files at runtime through an Excel worksheet function.
* Instantiation of Java objects, storing the object reference under a given object label.
* Invocation of methods on objects referenced by their object handle, storing the handle to the result under a given object label
Microsoft is offering a new service to allow you to do the same type of data mining in the plugin online. Simply upload your Excel spreadsheet of data and you have all the same functionality online that you did in the plugin.
The Apache POI team is pleased to announce the availability of Apache POI 3.5.1 beta 1, our first release including OOXML (Office Open XML) support. Apache POI is well-known in the Java field as a library for reading and writing OLE2 office file formats, such as Excel, PowerPoint, Visio and Word. With POI 3.5, it also support the new OOXML formats introduced in Office 2007.
Essentially what I did was to compare the Apache POI HSSF Api and the JExcelApi.
This reference describes the elements and attributes that make up the XML Spreadsheet (XMLSS) schema when the data in Excel 2002 spreadsheets and Microsoft Office XP Spreadsheet Components is exported to the Extensible Markup Language (XML) format.
In this article, I will show you how to create a new Excel output file and populate the file with discrete spreadsheets containing specific data from a database. We will Integration Services for the task
I'm working on a spreadsheet like component for AgileAgenda that I might end up turning into a general-purpose flex component at some point.
With Office 2007, no third-party libraries are necessary-a Java application can now read and write any Office 2007 document, because Office 2007 documents are now nothing more than ZIP files of XML documents known as the OpenXML
jXLS is small and easy-to-use Java library for generating Excel files using XLS templates. Also jXLS can be used to read XLS files and populate Java beans with spreadsheet data according to XML configuration file
I'm simply not going to bother with the hassle, trouble, expense, and complexity of desktop applications when an online substitute will do the job anymore. Life's too short already.
After quite a wait, version 3.0 of Apache Jakarta POI has now been released. The POI project consists of APIs for manipulating files based on Microsoft's OLE 2 Compound Document format using Java. In short, you can read and write MS Excel files using Java
Scand has announced the release of dhtmlxGrid v.1.1, JavaScript grid component which brings Excel-like functionality on the web. Besides Ajax support, rich cell editing capabilities and client-side sorting presented in previous version, dhtmlxGrid v1.1 de
