TeamDev Support : All Content - JExcel

JExcel 1.4 Release Notes

roman.kazmin@teamdev.com — Wed, 28 Oct 2009 11:29:56 GMT

New Features and Improvements:

Added the delete() method to Range class.
Updated JExcel FileFormat enumeration with the latest formats.
The following properties are added to the Window class:
- DisplayGridlines
- DisplayOutline
- DisplayWorkbookTabs
- DisplayHeadings
- DisplayVerticalScrollBar
- DisplayHorizontalScrollBar
- DisplayFormulas
JExcel Application class has been extended with DisplayAlerts property to allow controlling Excel alerts.
Added wrappers for ForumulaArray and Formula properties to Range class.
JExcel is now using the SLF4J Logging Facade that allowing the end user to plug in the desired logging framework at deployment time.
Added Ctrl+S keyboard shortcut to "Save" option (JExcel Demo).
Added ability to open several windows of JExcel Demo (JExcel Demo).

Resolved Issues:

Issue with opening new Excel file formats.
Issues with closing Popup menus immediately after opening.
Excel repainting issues in JWorkbook component.
Issue with closing EXCEL.EXE process after closing all opened JWorkbook components.
Memory leak issues with releasing JExcel application.
Focus handling issues between several opened JWorkbook.
Conflicts/focus handling issues between opened JWorkbook components and Excel windows.
Issues with a 'Static View' mode of JWorkbook component.
Re-parenting issue in JWorkbook component.
Activation/deactivation issues with Excel toolbar in JWorkbook component.
Improved stability when switching between opened JWorkbook components and another Excel windows.
Issue with closing JWorkbook component.
Layout issues in JWorkbook component.
Issue with creating multiple JWorkbook components simultaneously.
Blinking issues when several JWorkbook instances are opened.
Issue with opening "Print Preview" mode.
Issue with closing Java process "javaw.exe" after closing the last JExcel Demo window (JExcel Demo).
Crash issue with JVM 1.6 (JExcel Demo).

Using JExcel under Eclipse

roman.kazmin@teamdev.com — Tue, 05 May 2009 05:52:46 GMT

Creating and configuring Java project

To use the JExcel in your project you need the JExcel distribution package and license files - jiniwrapper.lic, comfyj.lic and jexcel.lic. Unpack the JExcel package into any folder, and put the license files into bin subfolder.

Eclipse uses the bin folder to store its compiled files by default and JExcel uses this folder to store its native libraries like JNIWrapper and license files. That is why we recommend renaming Eclipse directory for class files before using (for example into “Eclipse_bin”). Otherwise, Eclipse will delete native libraries from the bin folder when you clear project build results.

Figure 1. Configuring eclipse project

Copy the JExcel distribution folder into your new project folder. This is not obligatory but it makes the work process and writing of build scripts easier.

Configuring the Build Path

Please right click on the project in the project tree and select the Configure Build Path settings as shown in Figure 2:

Figure 2. Access to build path configure dialog

Add the jexcel-1.x.jar, jniwrap-3.x.x.jar, comfyj-2.x.jar and winpack-3.x.jar to the build path as shown in Figure 3 and Figure 4 .

Figure 3. Adding JExcel jars

Figure 4. Java Build Path configuring

Select the Source tab and double click on Native library location item. Set Location path to the bin folder (See Figure 5):

Figure 5. Native Library location configuring

Apply your changes and close the project properties dialog.

Now you can start your application by clicking the Run button. If you have done everything correctly your application will be started.

JExcel Installation Instructions

roman.kazmin@teamdev.com — Thu, 08 Jan 2009 12:14:17 GMT

Installing Library JAR File

JExcel uses JNIWrapper, ComfyJ and WinPack products, so all these JAR files should be in the application class path.

Native JNIWrapper library (jniwrap.dll) is required for JExcel and it should be placed in the working directory of a Java application.

Installing License File

The JExcel library requires valid license file(s): jexcel.lic, comfyj.lic and jniwrap.lic. License file(s) is not the part of this package and should be obtained separately. Visit TeamDev site (http://www.teamdev.com) to purchase the product or get an evaluation license.

License file(s) has to be installed in the same directory as the native code library or in the META-INF subfolder of any jar library from the application's classpath.

Warning: Do NOT rename the license file or it will not be recognized.

JExcel Technical Questions and Answers

roman.kazmin@teamdev.com — Thu, 08 Jan 2009 12:02:49 GMT

Get answers to most commonly asked technical questions about JExcel. If you don’t find the answer here, please send us your question using the support request form and we will add it to this FAQ section after answering you.

1. Why is an embedded workbook less functional than the ordinary one?

Answer: Unfortunately, it is impossible to implement the functionality of an ordinary Microsoft Excel workbook using OleContainer because of various native component limitations.

2. Why doesn’t an embedded workbook repaint while native dialogs are moving over it?

Answer: Native dialogs should be opened inside the OLE message loop of OleContainer. Use OleMessageLoop.addAction() to open the dialog

JExcel Troubleshooting

roman.kazmin@teamdev.com — Thu, 08 Jan 2009 11:41:23 GMT

1. A valid license is installed, but JExcel does not load displaying the message "JExcel license not found."

Cause: The license file is not installed in the same directory with the native code library or its name is incorrect. The license file should be named jexplorer.lic and located in the same directory as the JNIWrapper native library (jniwrap.dll on Win32 or libjniwrap.so on Linux). If any of these conditions is not met JNIWrapper will be unable to find the license file.

Solution: Make sure that the license file is named and placed properly.

2. A valid license jexcel.lic is installed, but JExcel does not load displaying the message "JNIWrapper license not found."

Cause: The JNIWrapper license file is not installed in the same directory with the native code library or its name is incorrect.

Solution: Make sure that the license file is named and placed properly.

3. JNIWrapper, ComfyJ and JExcel licenses are installed, but JExcel does not load displaying the message "JNIWrapper license not found. Checked licenses: [..\jexplorer.lic - not valid product]"

Cause: The jexcel.lic license file is not valid for the product that you use.

Solution: Make sure that you use the correct license for JExcel product.

JExcel 1.3 Release Notes

forum-admin@teamdev.com — Wed, 29 Oct 2008 11:26:32 GMT

New Features:

Added the getValues() functionality into Range class for bulk reading operations.
Added the copyWorksheet() method to the Workbook class for copying a Worksheet.
Added the mergeWorkbook() methods to the Workbook class for merging Workbooks.
Added the displayHeadings() method to the Worksheet class for hiding and displaying headings.
Added the allowMacros() method for disabling/allowing macros execution.
Added the setAutoFit() method to the Range class.

JExcel 1.2 Release Notes

forum-admin@teamdev.com — Thu, 08 May 2008 12:50:55 GMT

New Features and Improvements:

Added getRowCount() and getColumnCount() methods for Range class.
fillWithArray() method implementation is improved by using setValue2 MS Excel interface, speeding up bulk operations for large data sets.
Added setSaved() method for Workbook class for forcing “saved” status.
Native Peer setValue2() functionality is exposed for Range object.

Fixes:

Added COM exception handling for deleteRow() and deleteColumn() methods.
Memory leak fixes in RangePresentation inherited classes.
Fixed CLSID checking for XLSM format (MS Excel 2007 Macro-Enabled Workbook).
Fixed XLS file opening issue when working using MS Office 2007.
Fixed save() method from JWorkbook class to correctly save an opened document.
Fixed file reference storage for saveAs() method of JWorkbook class.

Other:

Some new samples based on customer support requests are added to JExcel package.
Fixed “Save” and “Save as...” menu items in JExcel demo application.

JExcel 1.1 Release Notes

forum-admin@teamdev.com — Thu, 08 Nov 2007 12:51:52 GMT

New Feature and Improvements:

Added protect/unprotect features for the Worksheet class.
Added the getUsedRange method for the Worksheet class.
Added delete/insert functionality for columns/rows in the Worksheet class.
Added save() and saveAs() methods for JWorkbook.
Added the ability to specify the order of cells in the resulting list of the Range.getCells() method.
Added the ability to declare the getWorkbook() method from the JWorkbook class as public.
Added isLogical() and getLogical() methods to the Cell class to allow getting a value of boolean expressions.

Fixes:

Fixed the problem with creation of JWorkbook in static mode.
Fixed the exception occurred while closing JWorkbook in static mode.
Fixed the exception occurred during printing of an Excel file.
Fixed the problem with incorrectly obfuscated Excel stubs inside the JExcel library.
Fixed JVM crash on Workbook.saveAs method when JExcel is running with MS Excel 2000.
Fixed "FunctionExecutionException: invalid vtbl" exception occurred when calling Application.openWorkbook() method in Excel 2000.
Fixed the problem with releasing of the Excel document after closing the JWorkbook component.

JExcel 1.0 Release Notes

forum-admin@teamdev.com — Tue, 04 Apr 2006 12:52:30 GMT

Changes since version 1.0 Beta:

Removed ability to access the underlying Workbook object of JWorkbook to avoid ambiguity.
Added ability to interrupt JWorkbook closing.
Added ability to fill the cells Range with an array of values.
JWorkbook, JWorkbookEventListener, JWorkbookEventAdapter, JWorkbookEventObject moved to com.jniwrapper.win32.jexcel.ui package.
Border, Font, InteriorPattern, TextAlignment, TextOrientation moved to com.jniwrapper.win32.jexcel.format package.
JWorkbook and Workbook classes now implement the common GenericWorkbook interface.
Workbook.getPeer() renamed to getNativePeer().

Fixes:

Fixed "Object is not connected to server" problem occurred while creating new workbook.
Fixed problem with repainting workbook in "static mode" in JExcel Demo.

JExcel Demo:

JExcel Demo source are now available in distribution.
"Save Copy As..." dialog opens when closing a workbook that was modified.

JExcel Beta1

forum-admin@teamdev.com — Wed, 28 Dec 2005 12:57:46 GMT

New:

Initial Beta Release.