JExcel explained
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.[2] [3] [4]
JExcel support is discontinued as of May 31, 2020.[5]
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[6]
See also
External links
- – the official JExcel page.
- - the JExcel Support website containing documentation, release notes and examples.
Notes and References
- Web site: JExcel Product Licence Agreement. 2 February 2016. TeamDev. TeamDev.
- Web site: recall. 2 February 2016. Recall.
- Web site: JExcel 1.7. 2 February 2016. GearDownload. GearDownload.
- Web site: JExcel 1.7. 2 February 2016. Directory of Shareware . Directory of Shareware.
- Web site: JExcel Product Website. TeamDev. TeamDev .
- Web site: Reading\writing workbook attributes. Setting password. Saving workbook in MS Excel 2003 format . 2 February 2016. JExcel Support. JExcel Support.