Java to SpreadsheetML / News: Recent posts

Xelem is a compact Java-library to read and write Excel files of type SpreadsheetML.

What about supplying your (web)clients with the set of data they need in a dynamically created Excel workbook? With xelem you'll create and format a spreadsheet, then send it down the line with just a few lines of code.

Reading data from spreadsheets? The xelem.lex-package provides a concise API for reading spreadsheets, either from a file or an inputsource. It offers a flexible event-based model as well as a simple getWorkbook-method.... read more

Xelem is a compact Java-library to read and write Excel files of type SpreadsheetML. It can produce sophisticated, intricate and complex spreadsheets from within any Java program. And now, since the release of xelem.2.0, it can read SpreadsheetML.

xelem features:
- reading and writing xml-spreadsheets
- process spreadsheet data
- inspect spreadsheet structures
- transform spreadsheets
- and do all of this in a truly object-oriented environment... read more

This minor release fixes the problem that prevented xelem from working properly under Java.1.5. It also introduces the uses of templates.

Xelem is a compact Java library that enables the creation of Excel spreadsheets from within any Java (web)application. With a few lines of code all your data is at your disposal in a spreadsheet, ready to do calculations, analyses and information retrieval.

Xelem features:
- intuitive creation of workbooks and worksheets;
- the overloaded setData-methods of the SSCell class will accept all Java primitive values and objects;
- format your sheets and data by applying styles which you create WYSIWYG-like in your Excel-application;
- easy construction of formulas, using the absolute and relative range-references of Address and CellPointer;
- freeze panes, apply auto filtering, set grid and tab colors and customize many more worksheet options with just a line of code;
- serialize your workbook to a Writer, OutputStream or File.... read more