How to create an excel file in google app engine (java)?

Question

A question that seems to have quite a few options for Python, but none for Java after googling for two days. Really really could use some help all I have found so far is a recommendation to use gaeVFS to build an excel file from the xml components and then zip it all together which sounds like a slap in the face. Oh yes and if you were wondering I am questioning my use of Java rather than python but at 5,000 lines of code it would be insane to turn back now...

Other things you might find useful

• Client: GWT
• Server: Servlets running on google app engine storing data into the google data store
• Excel file: mandatory, CSV isn't good enough, no need to save the file just to be able to "serve" it to the client i.e. open a "Save As" box.

Answer 1

google app engine do not support input/output stream classes, you need to use google app engine virtual file system.

Answer 2

Try this : http://code.google.com/p/gwt-table-to-excel/

Answer 3

Take a look at this post. It's a step by step tutorial on how to generate excel files on google app engine.

Answer 4

You could also take a look at the Apache POI project. You can read and write MS Excel documents with this library.

Answer 5

Have you checked out this api already: Java Excel API ?