Librairies Java

Voir aussi:

File format

Microsoft Documents

Apache POI

http://poi.apache.org/

the Java API for Microsoft Documents. Voir la Apache POI - Component Overview pour la liste des formats “Microsoft Office” supportés (97-2003-2007, 2007+, OOXML …)

Excel API

jexcelapi

http://jexcelapi.sourceforge.net/ (Last Update 2010-03-24)

Java Excel API is a mature, open source java API enabling developers to read, write, and modifiy Excel spreadsheets dynamically. Now java developers can read Excel spreadsheets, modify them with a convenient and simple API, and write the changes to any output stream (e.g. disk, HTTP, database, or any socket). Any operating system which can run a Java virtual machine (i.e., not just Windows) can both process and deliver Excel spreadsheets. Because it is Java, the API can be invoked from within a servlet, thus giving access to Excel spreadsheets over internet and intranet web applications.

Some Features:

Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks
Reads and writes formulas (Excel 97 and later only)
Generates spreadsheets in Excel 2000 format
Supports font, number and date formatting
Supports shading, bordering, and coloring of cells
Modifies existing worksheets
Is internationalized, enabling processing in almost any locale, country, language, or character encoding (formulas are currently only supported in English, French, Spanish, and German, but more can be added if translated)
Supports copying of charts
Supports insertion and copying of images into spreadsheets
Supports logging with Jakarta Commons Logging, log4j, JDK 1.4 Logger, etc
…and much more

Communication

Ganymed SSH-2 for Java

http://www.cleondris.ch/opensource/ssh2/

Ganymed SSH-2 for Java is an open source library which implements the SSH-2 protocol in pure Java (tested on J2SE 1.4.2 and 5.0). It allows one to connect to SSH servers from within Java programs. It supports SSH sessions (remote command execution and shell access), local and remote port forwarding, local stream forwarding, X11 forwarding, SCP and SFTP. There are no dependencies on any JCE provider, as all crypto functionality is included. Originally, Ganymed SSH-2 for Java was developed for the Ganymed replication project at ETH Zurich (Switzerland).