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

Top N Queries

Not really java but what the heck: http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html

Setting up Eclipse with JavaFX

Here's how you do it: JavaFX for Eclipse

Confused about inner and outer classes?

Well here's a very good article, which cleared alot of my doubt especially when using my DAO methods which uses anonymous inner classes:

Nested Classes
Examples based

Is it FINAL?

Here's a very good article that summarizes why/how/when the final keyword should be used :

The Final Word On the final Keyword