[java] Export to excel

Don't bother. Just export the data as CSV, with SQL and regular old print statements, then read that in with Excel.

If you want to have some nicely formatted output, you can use html-tables to build the "excel" file thus being able to format cells (color, size, font, etc.).
Then save the file with a .xls extension and start excel with the file as a parameter or double click on the file (windows should recognize the .xls extension as "Excel").

I did that some years ago with quite good results. There's a library that can write true Excel, too. Unfortunately I don't remember the name since I found it to be using way to much memory and thus didn't use it in my project.

A library would be Apache POI (http://poi.apache.org/). I would got with that or try to fire your Makro through the command line by runtime.

Quote:

Original post by INsanityDesign A library would be Apache POI (http://poi.apache.org/). I would got with that or try to fire your Makro through the command line by runtime.

Hey Friend,

Most of people told me same as you told "Apache POI" is very good for programming related solution, but still i can't got any solution. can you please provide me macro regarding for this one.

Thanks :)

Asking questions.

What, exactly, are you having problems with? What have you tried already? Why wasn't that suitable or why didn't it work?