JExcel

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.

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 { public static void main(String[] args) throws Exception { //Start MS Excel application, crate workbook and make it visible. // Application starts invisible and without any workbooks Application application = new Application(); Workbook workbook = application.createWorkbook("Custom title"); printWorkbookAttributes(workbook); modifyWorkbookAttributes(workbook); File newFile = new File("Workbook.xls"); //Save workbook in Excel 2003, to save in Excel 2007 format use FileFormat.OPENXMLWORKBOOK // format specificator and *.xlsx extension workbook.saveAs(newFile, FileFormat.WORKBOOKNORMAL, true); File workbookCopy = new File("WorkbookCopy.xls"); workbook.saveCopyAs(workbookCopy); //Close workbook saving changes workbook.close(true); //Reopening the workbook workbook = application.openWorkbook(newFile, true, "xxx001"); printWorkbookAttributes(workbook); //Perform cleanup after yourself and close the MS Excel application forcing it to quit application.close(true); } /** * Prints workbook attributes to console * @param workbook - workbook to print information about */ public static void printWorkbookAttributes(GenericWorkbook workbook) { String fileName = workbook.getFile().getAbsolutePath(); String name = workbook.getWorkbookName(); String title = workbook.getTitle(); String author = workbook.getAuthor(); System.out.println("\n[Workbook Information]"); System.out.println("File path: " + fileName); System.out.println("Name: " + name); System.out.println("Title: " + title); System.out.println("Author: " + author); if (workbook.hasPassword()) { System.out.println("The workbook is protected with a password"); } else { System.out.println("The workbook is not protected with a password"); } if (workbook.isReadOnly()) { System.out.println("Read only mode"); } } /** * Modify workbook title, author and set password * @param workbook - workbook to modify attributes */ public static void modifyWorkbookAttributes(GenericWorkbook workbook) { workbook.setTitle("X-files"); workbook.setPassword("xxx001"); workbook.setAuthor("Agent Smith"); } }