Re-use your existing Excel files! Java application built with BIRT Spreadsheet Engine’s DLL
Re-use your existing Excel files! Java application built with BIRT Spreadsheet Engine’s Development Library
AIR has the knowledge and expertise acquired through experience and substantial deployment track record.
Contact Us. We’re here to help.
BIRT Spreadsheet Engine’s GUI tool, BIRT Spreadsheet Designer, allows you to easily embed definitions for database connection, data read process and data mapping into your spreadsheet template. There is no need for a developer to program a database connection for your spreadsheet system. The tool also allows you to link multiple data sources of different types and use them as a data set.
BIRT Spreadsheet Engine and API provide an Excel file output function. You can build a system based on Java application, applet or servlet, to output Excel spreadsheets. The Excel sheet output can be downloaded to the desktop for the end-user to process the data with ease.
– Generate Excel (xls and xlsx)
– Convert to PDF, HTML and text formats
– Set document format
– Execute numerical operations
– Insert various objects
As Java is able to read from your existing Excel files, migration will require minimal steps. You can also reuse Excel files that were in use in your existing system, thus leveraging your legacy assets, reducing the effort needed to design templates in Java.
Many Excel features, such as the pivot table and security settings with password, are available with no difference.
Moreover, 2D and 3D graphs from Excel can be output to JPG, GIF and PNG files. Option settings for graphics are simplified by the use of intuitive, Excel-like point and click operations, to add graphs, set formats and specify data binds.
In addition, an image map is generated automatically, which enables drilling down from graphs and image data to other reports, graphs and sources of information. As JSP graph API is provided, there is no need to write any Java code.
– Wide range of graphs and charts (vertical and horizontal bar, area, line, pie, scatter, doughnut, bubble and stock)
– Insert images and texts
– Pivot table (created either via the Java application or BSS Designer)