| Issue 327: | Export Excel - max row num | |
| 1 person starred this issue and may be notified of changes. | Back to list |
What steps will reproduce the problem? 1. Export excel with Apache poi 2. Rows number exceed max number Excel 2003 When I try to export an excel file that exceeds the limit of Excel 2003 I get an error of maximum number of lines exceeded. I know that Excel 2007 allows you to export a greater number of rows in Excel 2003, but to ensure compatibility with the 2007 I use XSSF. I wanted to know if you can tell Jmesa using these Interfaces. thanks Pierluigi
Sep 27, 2011
Project Member
#1
jeff.johnston.mn@gmail.com
Nov 15, 2011
Hi Mr Johnston, I checked the implementation of the class ExcelView, and I changed the render method to use XSSF, but the problem now is that when the export is call, the jmesa implementation invoke the method exports of the class ExcelViewExporter that, explicitly, use the class HSSFWorkbook, when it should use the interface Workbook. How can I solve the problem by calling my custom exports method ?
Nov 15, 2011
>>How can I solve the problem by calling my custom exports method ? Not at the moment. Its unfortunate as it is pretty much the only thing in JMesa that is not easily exposed. But it is still possible...here is a link to a thread that is a similar flavor of this problem. http://groups.google.com/group/jmesa_forum/browse_thread/thread/860aa8cf8049e5ac In a nutshell you could change the code to use the interface, or get a patch into JMesa to make the feature plugable, or follow the thread (above) and do that. If you wanted I could recompile the code with the interface change and I could send you a custom jar file too...just send me an email at jeff.johnston.mn@gmail.com. As that thread talks about at the beginning of next year I am going to get some time to improve this too. |