Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
Test to Read Excel File as CSV with jxl.jar
How to run the test to read an existing Excel file as CSV output with jxl.jar?
✍: FYIcenter.com
The following steps shows you how to run the test to read an existing Excel file as CSV output 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 -csv jxlrwtest.xls | more *** original **** Java Excel API Modify Test ,,,,Bold,4dps Labels,,,MulRK records - no modification,1,2.0000,3,4,5,6,7 Underlined cell - now emboldened,Underlined Bold cell - now underlined,Bold 12pt font - now 10pt,12pt,,All entries Label - now has the word mod after it,Label,,in this column ,,,are Numbers,,,bold Pi - 5 dps, now 7,3.14159,,arial 15042699 - Now exponential + 4dps,15042699 15042699 - Exponential + 5dps - now normal,1.50427E07 Number 17 - now 42,17 Number 2.71828 - add 0.1,2.718 Date - 31st May, 1976 14:53:21,,,Boolean Value,true Standard format dd/MM/yyyy hh:mm - now dd MMM yyyy hh:mm:ss,5/31/76 14:53 Custom format dd MMM yyyy hh:mm:ss- now standard M dd yy hh:mm,31 May 1976 02:53 :21 Set the date to be 18 February, 1998 11:23:28format dd MMM yyyy hh:mm:ss- now st andard M dd yy hh:mm,31 May 1976 02:53:21 Formula - Simple sum. Modify one of the values,1.1 -- More --
⇒ Test to Read Excel File as XML with jxl.jar
2018-04-07, 1848🔥, 0💬
Popular Posts:
What Is poi-ooxml-3.5.jar? poi-ooxml-3.5.jar is one of the JAR files for Apache POI 3.5, which provi...
How to download and install JDK (Java Development Kit) 6? If you want to write Java applications, yo...
This package is the backport of java.util.concurrent API, introduced in Java 5.0 and further refined...
How to download and install ojdbc6.jar for Oracle 11g R2? ojdbc6.jar for Oracle 11g R2 is a Java 6, ...
io.jar is a component in iText Java library to provide input/output functionalities. iText Java libr...