Though there is already support for the xml based file format in HSSF (the XSSF strand I believe) I think it unlikely that you will find such an API as most aim for some measure of backward compatibility - the limit to the number of rows has only recently been overridden if I remember correctly. As you probably know HSSF does not support the creation or modifcation of macros yet (though I am sure that any help to modify the application would be welcomed).
There are commercial products you might wish to look at and there is a good list available here; http://schmidt.devlib.org/java/libraries-excel.html One other route you may want to look at is COM. This does have limitations but allows you to manipulate the Excel application itself so there is almost no limit to what you could do. The other option is to look at OpenOffice; I seem to remember that it is possible to access the libraries that comprise this application and that may be one route to those features you seek. P.S. HSSF does support macros in that it will preserve them when opening/copying an existing workbook. Many people choose to create a template containing those macros they will need and use this as the base for the creation of a workbook. --- On Thu, 11/27/08, navjamsster <[EMAIL PROTECTED]> wrote: From: navjamsster <[EMAIL PROTECTED]> Subject: Java API to support xlsm format (office 2007) and create more than 65536 rows To: [email protected] Date: Thursday, November 27, 2008, 3:05 AM Is there any JAVA API open source or license product which generate more than 65536 rows in Excel throug java application? Are they support for macros(xlsm or xlsx format)? -- View this message in context: http://www.nabble.com/Java-API-to-support-xlsm-format-%28office-2007%29-and-create-more-than-65536-rows-tp20717321p20717321.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
