Categories:

Audio (13)

Biotech (29)

Bytecode (35)

Database (77)

Framework (7)

Game (7)

General (512)

Graphics (53)

I/O (32)

IDE (2)

JAR Tools (86)

JavaBeans (16)

JDBC (89)

JDK (337)

JSP (20)

Logging (103)

Mail (54)

Messaging (8)

Network (71)

PDF (94)

Report (7)

Scripting (83)

Security (32)

Server (119)

Servlet (17)

SOAP (24)

Testing (50)

Web (19)

XML (301)

Other Resources:

Test to Read Formulas from Excel File with jxl.jar

Q

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

✍: FYIcenter.com

A

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 --

Â

2018-02-21, 1432👍, 0💬

Popular Posts:

How to download and install ojdbc7.jar for Oracle 12c R1? ojdbc8.jar for Oracle 12c R1 is a Java 7 a...

JDK 11 jdk.aot.jmod is the JMOD file for JDK 11 Ahead-of-Time (AOT) Compiler module. JDK 11 AOT Comp...

commons-io-2.6-sources.j aris the source JAR file for Apache Commons IO 2.6, which is a library of u...

MXP1 is a stable XmlPull parsing engine that is based on ideas from XPP and in particular XPP2 but c...

ZooKeeper is a centralized service for maintaining configuration information, naming, providing dist...