Wednesday, July 29, 2009

Java and Spreadsheets

As part of my work, I deal with alot of Excel Spreadsheets and CSV (Comma delimited files).

Having a Java tool/program that can work with spreadsheets and csv would be extremely useful. I'm going to be dedicating this post to everything about this topic.

For starters, here are some freeware api/libraries that allows you to manipulate spreadsheets:
Java Excel API - A Java API to read, write, and modify Excel spreadsheets
Less Excel, More Components

GUI Spreadsheets:
Spreadsheet.java
Using JavaFX

JTable:
Sample Demo
Complex JTable Sample
Displaying a CSV File in a JTable
How to Use Tables

CSVs:
OpenCSV
Excel Comma Separated Values (CSV) - com.Ostermiller.util Java Utilities
Mindprod

No comments:

Post a Comment