How to run the test to read formulas from an existing Excel file with jxl.jar?

The following steps shows you how to run the test to read formulas from 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 -formulas jxlrwtest.xls | more

original
Formula in B26 value:  16.5 formula: SUM(B21:B25)
Formula in B27 value:  -0.573 formula: SIN((B24+B23-1.0)*9.0)
Formula in B80 value:  1.571 formula: modified!B10/2.0
Formula in F85 value:  0.333 formula: E85/3.0
Formula in G85 value:  1.333 formula: E85+F85
Formula in F86 value:  0.667 formula: E86/3.0
Formula in G86 value:  2.667 formula: E86+F86
Formula in F87 value:  1 formula: E87/3.0
Formula in G87 value:  4 formula: E87+F87
Formula in F88 value:  1.333 formula: E88/3.0
Formula in G88 value:  5.333 formula: E88+F88
Formula in F89 value:  1.667 formula: E89/3.0
Formula in G89 value:  6.667 formula: E89+F89
Formula in F90 value:  1.667 formula: E90/3.0
Formula in G90 value:  6.667 formula: E90+F90
Formula in F91 value:  1.667 formula: E91/3.0
Formula in G91 value:  6.667 formula: E91+F91
Formula in F92 value:  1.667 formula: E92/3.0
Formula in G92 value:  6.667 formula: E92+F92
Formula in F93 value:  1.667 formula: E93/3.0
Formula in G93 value:  6.667 formula: E93+F93
Formula in F94 value:  1.667 formula: E94/3.0
Formula in G94 value:  6.667 formula: E94+F94
-- More  --

⇒ Test to Modify Excel File with jxl.jar

⇐ Test to Read Excel File as XML with Format Properties

⇑ Demo Programs for jxl.jar

⇑⇑ FAQ for Java Excel API jxl.jar