Categories:
Audio (13)
Biotech (29)
Bytecode (22)
Database (79)
Framework (7)
Game (7)
General (497)
Graphics (53)
I/O (32)
IDE (2)
JAR Tools (70)
JavaBeans (16)
JDBC (86)
JDK (338)
JSP (20)
Logging (90)
Mail (54)
Messaging (8)
Network (106)
PDF (82)
Report (7)
Scripting (75)
Security (67)
Server (112)
Servlet (17)
SOAP (24)
Testing (55)
Web (24)
XML (287)
Other Resources:
Test to Read Excel File as XML with Format Properties
How to run the test to read an existing Excel file as XML output with cell format properties with jxl.jar?
✍: FYIcenter.com
The following steps shows you how to
run the test to read an existing Excel file as XML output with cell format properties 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 -xml -format jxlrwtest.xls | more <?xml version="1.0" ?> <!DOCTYPE workbook SYSTEM "formatworkbook.dtd"> <workbook> <sheet> <name><![CDATA[original]]></name> <row number="0"> <col number="0"> <data><![CDATA[Java Excel API Modify Test]]></data> <format wrap="false" align="general" valign="bottom" orientation="horizontal"> <font name="Arial" point_size="14" bold_weight="700" italic="false" underline="none" colour="black" script="normal" /> </format> </col> </row> <row number="1"> -- More --
2018-04-07, 762👍, 0💬
Popular Posts:
The SOAP with Attachments API for JavaTM (SAAJ) 1.3 provides the API for creating and sending SOAP m...
Apache Axis2 is the core engine for Web services. It is a complete re-design and re-write of the wid...
Java API for JavaServer Pages, specification version 2.0 JAR File Size and Download Location: File n...
iText is an ideal library for developers looking to enhance web- and other applications with dynamic...
The JDT project provides the tool plug-ins that implement a Java IDE supporting the development of a...