JExcel is a library (API) to read, write, display, and modify
Excel files with .xls or .xlsx formats. API can be embedded with
Java Swing and
AWT.
JExcel support is discontinued as of May 31, 2020.
Some features
Some main features are as follows:
* Automate Excel application, workbooks, spreadsheets, etc.
* Embed workbooks in a Java Swing application as ordinary Swing component
* Add event listeners to workbooks and spreadsheets
* Add event handlers to handle the behavior of workbook and spreadsheet events
* Add native peers to develop custom functionality.
Usage
Primary usage is handling Excel files through its API.
Example
Sample code for reading/writing workbook attributes, setting password, and saving MS Excel 2003 format, might look like as follows:
import com.jniwrapper.win32.jexcel.Application;
import com.jniwrapper.win32.jexcel.FileFormat;
import com.jniwrapper.win32.jexcel.GenericWorkbook;
import com.jniwrapper.win32.jexcel.Workbook;
import java.io.File;
/**
* This sample shows how to read/modify workbook attributes, how to save workbook in Excel 2003 format,
* and how to reopen workbook.
*
* The sample works with MS Excel in non-embedded mode.
*/
public class WorkbookSample
See also
*
Apache POI
Apache POI, a project run by the Apache Software Foundation, and previously a sub-project of the Jakarta Project, provides pure Java libraries for reading and writing files in Microsoft Office formats, such as Word, PowerPoint and Excel.
H ...
*
JXL (API)
*
Open Packaging Conventions
The Open Packaging Conventions (OPC) is a container-file technology initially created by Microsoft to store a combination of XML and non-XML files that together form a single entity such as an Open XML Paper Specification (OpenXPS) document. OPC- ...
*
Office Open XML software
This is an overview of software support for the Office Open XML format, a document file format for saving and exchanging editable office documents.
The list here is not exhaustive.
ECMA-376 1st edition implementations
The ECMA-376 1st edition ...
References
External links
* – the official JExcel page.
* {{citation , url = http://jexcel-support.teamdev.com/, title = JExcel Support - the JExcel Support website containing documentation, release notes and examples.
Microsoft Office-related software
Java platform
Java (programming language) libraries