JExcel

<h2 id="some-features">Some features</h2>
<p>Some main features are as follows:
</p>
<ul><li>Automate Excel application, workbooks, spreadsheets, etc.</li>
<li>Embed workbooks in a Java Swing application as ordinary Swing component</li>
<li>Add event listeners to workbooks and spreadsheets</li>
<li>Add event handlers to handle the behavior of workbook and spreadsheet events</li>
<li>Add native peers to develop custom functionality.<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a><a class="footnote-ref" id="fnref:6" href="#fn:6"><sup>6</sup></a><a class="footnote-ref" id="fnref:7" href="#fn:7"><sup>7</sup></a></li></ul>
<h2 id="usage">Usage</h2>
<p>Primary usage is handling Excel files through its API.
</p>
<h3>Example</h3>
<p>Sample code for reading/writing workbook attributes, setting password, and saving MS Excel 2003 format, might look like as follows:
</p>
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");
    }
}
<p><a class="footnote-ref" id="fnref:8" href="#fn:8"><sup>8</sup></a>
</p><h2 id="see-also">See also</h2>
<ul><li><a href="/facts/Apache_POI/wv7Qvscv">Apache POI</a></li>
<li><a href="/facts/JXL_(API)/bzlfxwHm">JXL (API)</a></li>
<li><a href="/facts/Open_Packaging_Conventions/Cj36HX3a">Open Packaging Conventions</a></li>
<li><a href="/facts/Office_Open_XML_software/cuhpElSM">Office Open XML software</a></li></ul>

<h2 id="external-links">External links</h2>
<ul><li><a href="https://www.teamdev.com/jexcel"><i>JExcel</i></a> – the official JExcel page.</li>
<li><a href="http://jexcel-support.teamdev.com/"><i>JExcel Support</i></a> - the JExcel Support website containing documentation, release notes and examples.</li></ul>

<h2 id="references">References</h2>

<ol>
<li id="fn:1"><p>"recall". Recall. Archived from the original on 2 February 2016. Retrieved 2 February 2016. <a href="https://web.archive.org/web/20160202105714/https://recalll.co/app/?q=excel%20-%20Java%20POI%20API:%20Convert%20from%20*.xlsx%20to%20*.xls" target="_blank">https://web.archive.org/web/20160202105714/https://recalll.co/app/?q=excel%20-%20Java%20POI%20API:%20Convert%20from%20*.xlsx%20to%20*.xls</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li>
<li id="fn:2"><p>"JExcel 1.7". GearDownload. GearDownload. Retrieved 2 February 2016. <a href="http://www.geardownload.com/development/jexcel.html" target="_blank">http://www.geardownload.com/development/jexcel.html</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li>
<li id="fn:3"><p>"JExcel 1.7". Directory of Shareware. Directory of Shareware. Retrieved 2 February 2016. <a href="http://www.directoryofshareware.com/preview/jexcel" target="_blank">http://www.directoryofshareware.com/preview/jexcel</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li>
<li id="fn:4"><p>"JExcel Product Website". TeamDev. TeamDev. <a href="https://www.teamdev.com/jexcel" target="_blank">https://www.teamdev.com/jexcel</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li>
<li id="fn:5"><p>"recall". Recall. Archived from the original on 2 February 2016. Retrieved 2 February 2016. <a href="https://web.archive.org/web/20160202105714/https://recalll.co/app/?q=excel%20-%20Java%20POI%20API:%20Convert%20from%20*.xlsx%20to%20*.xls" target="_blank">https://web.archive.org/web/20160202105714/https://recalll.co/app/?q=excel%20-%20Java%20POI%20API:%20Convert%20from%20*.xlsx%20to%20*.xls</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li>
<li id="fn:6"><p>"JExcel 1.7". GearDownload. GearDownload. Retrieved 2 February 2016. <a href="http://www.geardownload.com/development/jexcel.html" target="_blank">http://www.geardownload.com/development/jexcel.html</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></p></li>
<li id="fn:7"><p>"JExcel 1.7". Directory of Shareware. Directory of Shareware. Retrieved 2 February 2016. <a href="http://www.directoryofshareware.com/preview/jexcel" target="_blank">http://www.directoryofshareware.com/preview/jexcel</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></p></li>
<li id="fn:8"><p>"Reading\writing workbook attributes. Setting password. Saving workbook in MS Excel 2003 format". JExcel Support. JExcel Support. Retrieved 2 February 2016. <a href="https://sites.google.com/a/teamdev.com/jexcel-support/samples/basics/reading-and-writing-workbook-attributes-setting-password-saving-workbook-in-ms-excel-2003-format" target="_blank">https://sites.google.com/a/teamdev.com/jexcel-support/samples/basics/reading-and-writing-workbook-attributes-setting-password-saving-workbook-in-ms-excel-2003-format</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></p></li>
</ol>

JExcel open-in-new

JExcel