1. Some features

2. Usage
    Example 

3. See also

4. References

5. External links

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.

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.^[2][3][4]

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

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

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

        //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("\[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");    }

}

See also

• Apache POI
• Aspose API
• JXL (API)
• Open Packaging Conventions
• Office Open XML software

References

External links

• {{citation | url = https://www.teamdev.com/jexcel| title = JExcel}} – the official JExcel page.

• Chah-e Darba
• Chah-e Darbas
• Chah-e Darbast
• Chah-e Darman
• Chah-e Dar Mohammad
• Chah-e Darmohammad Makam
• Chah-e Darvish
• Chah-e Darvish Azadi
• Chah-e Dashi
• Chah-e Dasht-e Taleqani
• Chah-e Dasht Mohammad Khan 1
• Chah-e Dasht Mohammad Khan 11
• Chah-e Dasht Mohammad Khan 12
• Chah-e Dasht Mohammad Khan 13
• Chah-e Dasht Mohammad Khan 15
• Chah-e Dasht Mohammad Khan 3
• Chah-e Dasht Mohammad Khan 4
• Chah-e Dasht Mohammad Khan 5
• Chah-e Dasht Mohammad Khan 6
• Chah-e Dasht Mohammad Khan 7
• Chah-e Dasht Mohammad Khan 8
• Chah-e Dasht Mohammad Khan 9
• Chah-e Davood
• Chah-e Dazu
• Chah-e Deh-e Inach