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

Sending emails using Java

Here are some very useful links on how to use JavaMail:

E-Mailing Through Java
Sending email with Java
Sending e-mail in Java: There's more than one way
Java - Sending Email

Getting started on EJBs

I wanted to schedule some monitoring jobs in my J2EE container and intend to use EJB Timer to do it. I'm researching on good links on how to use Eclipse for EJBs.

Here are some:

EJB Fundamentals:
An Introduction to Enterprise JavaBeans
Building your first EJB

EJB on Glassfish
EJB FAQ
EJB 3 Development for Glassfish using Eclipse 3.2 Tutorial

Building EJBs in Eclipse:
WTP Tutorials - Building a Simple EJB Application
Java EJB 3 tutorial using Eclipse, Ant and JBoss Tutorial

Using EJB Timer:
Using Timers in J2EE Applications
EJB 3 Timer Service