When neither -csv nor -xml is specified, -csv is assumed. These examples read budget.xls and output its contents in CSV and XML format to standard output. Consider the following examples: java -jar jxl.jar -csv budget.xls

The read demo reads an existing spreadsheet, converting it to comma-separated value (CSV) or XML format via the -csv or -xml command-line option. Q: Does the JExcelAPI library contain any demos?Ī: JExcelAPI's jexcelapi home directory contains a jxl.jar file that contains demos for reading, writing, and copying spreadsheets. You should observe a jexcelapi home directory within a jexcelapi_2_6_12 directory. Go ahead and save the file.įollowing the download, unarchive this file.

After a short delay, your browser should prompt you to save this file.

For example, I clicked the jexcelapi_2_6_12.zip link.

On the resulting page, click the distribution archive filename.

On the resulting page, click one of the folder links.

Point your browser to JExcelAPI's SourceForge site.

Downloading the JExcelAPI libraryĪ: Complete the following steps to download JExcelAPI: JExcelAPI was developed by Andrew Kahn and was released under the GNU Lesser General Public License.

Supports the insertion and copying of images into spreadsheets.

Supports cell shading, cell bordering, and cell coloring.

Supports font, number, and date formatting.

Generates spreadsheets in Excel 2000 format.

Reads and writes formulas (Excel 97 and later only).

Reads data from Excel 95, 97, 2000, XP, and 2003 workbooks.

Home budget spreadsheet open source