TeamDev Support : Document List - JExcel

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.