JExcel explained
| JExcel |
| Developer: | TeamDev |
| Latest Release Version: | 1.7 |
| Operating System: | Cross-platform |
| Programming Language: | Java |
| Genre: | API to access Microsoft Excel format |
| License: | TeamDev[1] |
| Website: | https://www.teamdev.com/jexcel |
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. 2 February 2016. https://web.archive.org/web/20160202105714/https://recalll.co/app/?q=excel%20-%20Java%20POI%20API:%20Convert%20from%20*.xlsx%20to%20*.xls. dead.
- 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.
