JExcel

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");    }}