Test to Modify Excel File with jxl.jar

Q

How to run the test to modify an existing Excel file with jxl.jar?

✍: FYIcenter.com

A

The following steps shows you how to run the test to modify an existing Excel file with jxl.jar:

1. Open command line window to verify jxl.jar installation. "jxl.jar" file and "jxlrwtest" file are needed:

C:\cd \fyicenter\jexcelapi

C:\fyicenter\jexcelapi>dir
10/24/2009  10:11 AM           725,735 jxl.jar
09/07/2009  03:26 PM            93,696 jxlrwtest.xls
...

2. Use the "java -jar" command to run the test program:

C:\fyicenter\jexcelapi>\local\jdk-1.8.0\bin\java 
   -jar jxl.jar -rw jxlrwtest.xls out.xls

Input file:  jxlrwtest.xls
Output file:  out.xls
Reading...
Copying...
Modifying...
Done

3. Open the output file, out.xls, with Microsoft Excel. You see two tabs in the Excel file: "original" and "modified".

4. Click "modified" tab. You see modified spreadsheet data:
jxl.jar Text - Modify Excel Cell Data

 

Demo Programs for jxl.jar

⇒⇒FAQ for Java Excel API jxl.jar

2018-02-21, 653👍, 0💬