My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 327: Export Excel - max row num
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by pusa...@gmail.com, Sep 26, 2011
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
I am not familiar with XSSF. You should take a look at the ExcelView and JExcelView and find out if there is anything that we could change to get past the maximum number of lines. 

If you had to you could limit the number of lines that are exported or create another excel view that put data in multiple worksheets. 
Nov 15, 2011
#2 pusa...@gmail.com
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
Project Member #3 jeff.johnston.mn@gmail.com
>>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.






Powered by Google Project Hosting