Writing more than 65000 rows into excel

http://www.birt-exchange.org/org/forum/index.php/topic/20457-writing-more-than-65000-rows-into-excel/

Find more posts tagged with

Comments

Arpan,

Did you replace all the jars in 2.5.1 with the ones from 2.5.2, or just the XLS emitter jar? I think Jason wanted you to try just replacing the XLS emitter jar. I don't know if the Tribix XLS emitter for 2.5.1 will be any different, but you could try it as well.

thuston

The XLS file format cannot use more than 65k rows per sheet.
You can write a file larger, but Excel can't show it to you. Make sure you output as Excel 2007 XLSX to allow for more data.

Megha Nidhi Dahal

Thanks for your responses.

@Michael,

I tried replacing every jars in 2.5.1 with jars from 2.5.2, but still I'm unable to write more than 65k rows. I'm caught up in something else as of now, I may need a week to really start looking into it once again, may be then we will have a series of questionnaire

@thutson,

I'm aware that xls does not support more than 65k rows in a sheet, well I'm okay even if it shows in different sheet, as long as the data is not lost.
I tried giving the file format as xlsx in the RenderOption (options.setOutputFormat("xlsx")), but it says unsupported format xlsx. I will start looking into it once again after a couple of days, then may be I can post some better doubts.

Once again, thanks a lot for your time.

regards
Arpan

Megha Nidhi Dahal

I wanted to know what is the latest stable version for BIRT. A wiki entry <a class='bbc_url' href='http://en.wikipedia.org/wiki/BIRT_Project'>BIRT Project Wiki</a> shows versions up to 2.6.1 which is to be released this month. 
 
I guess, the only solution to my problem would be to migrate to later versions, so why not to the latest

. 
 
Also, does these newer versions'(post 2.5.1) options.setOutputFormat support xlsx extension? 
 
regards 
Arpan

Megha Nidhi Dahal

I have integrated 2.6 just as a try, and the above problem is solved. Now I get xls file with multiple sheets no matter how many number of rows it has to display.

I also have some pdf reports apart from these xls reports, but the formatting for the pdf reports has slightly modified. The font sizes are larger than what 2.5.1 was writing. I guess medium in 2.5.1 and 2.6.0 are not same.

Not much of an issue, please make me aware of any other thing that I have to take care. Also whether I can stick on to 2.6.0.

regards
Arpan

mwilliams

Arpan,

Yes, the font sizes were changed for "small", "medium", etc. You can see the changes made in each version by looking at the project plan on eclipse.org. There shouldn't have been any major changes that will affect your reports besides the font size deal, I don't think. You may just run each report in the new version and double check that there are no errors before deploying them out for production.

Megha Nidhi Dahal

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="68613" data-time="1285074896" data-date="21 September 2010 - 06:14 AM">
You may just run each report in the new version and double check that there are no errors before deploying them out for production.

</blockquote>
 
Michael, 
 
For sure, I've got to watch my back

Thanks Arpan