java API for excel 2007

[navjamsster]

Is there any JAVA API (open source or license product) which generate more than 65536 rows in Excel throug java application and support for macros(xlsm or xlsx format)?

[Dököll]

Greetings!

I am not trying to avoid an answer for you, but if it is so much trouble to find such an API, why not move on to something more endearing like adding data to an SQL server database, or even an Access back-end!

What is your purpose for using more that allowed rows in excel, if I may ask?

You can find a number of queries here adding to SQL db, if you're interested.

[JosAH]

Is there any JAVA API (open source or license product) which generate more than 65536 rows in Excel throug java application and support for macros(xlsm or xlsx format)?

Don't you love Microsoft for that? A new document format again ... The HSSF folks of the Apache POI project are working on their XSSF sub-project that is supposed to support the new Excel data format (version 3.5). It all has to be reverse enineering again because Microsoft never properly publishes their file formats ... You just have to wait a bit.

kind regards,

Jos

[Nepomuk]

I don't know if it supports those things, but have you tried using Apache POI?

Greetings,
Nepomuk

[JosAH]

I don't know if it supports those things, but have you tried using Apache POI?

Greetings,
Nepomuk

*cough* see my reply #3.

kind regards,

Jos ;-)

[Nepomuk]

Indeed, I had this thread open for too long it seems and therefore didn't see your reply when it appeared. *blush*

Greetings,
Nepomuk