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, 1906🔥, 0💬
Popular Posts:
How to run "jarsigner" command from JDK tools.jar file? "jarsigner" command allows you to digitally ...
What Is wstx-asl-3.2.8.jar? wstx-asl-3.2.8.jar is JAR file for the ASL component of Woodstox 3.2.8. ...
What Is in Xerces-J-bin.2.12.2.zip? Xerces-J-bin.2.12.2.zip file is the distribution package ZIP fil...
kernel.jar is a component in iText Java library to provide low-level functionalities. iText Java lib...
Java Architecture for XML Binding (JAXB) is a Java API that allows Java developers to map Java class...