Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Birt generating large Excel files and duplicate Styles
Raghava
I have been using BIRT2.6 for report generation. But Excel files which are generated by BIRT are huge in size(160 MB,50 MB).When I opened one Excel file using 'EditPlus' textpad, I noticed more than 80% size occupied by <strong class='bbc'>style tags</strong>. And if cell's data type is number then style id is being increased by 2 or 1 and new style tag is getting created with that Id.Usually one cell should use one style across all rows but it's not happening. It's causing duplicate style info and leading to huge size. Please find attached excel sheet for reference.
Find more posts tagged with
Comments
JasonW
Can you open a bug for this?
Jason
tbl0605
<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="78696" data-time="1308321515" data-date="17 June 2011 - 07:38 AM"><p>
Can you open a bug for this?<br />
<br />
Jason<br /></p></blockquote>
<br />
This topic is a bit old now, and it seems that the bug has been fixed in the meantime<br />
but if anyone's interested, I've made a small java class that removes duplicate styles from an existing excel file (generated using Birt 2.6).<br />
<br />
Thierry.
Muthul
Hi Thierry,
We also experience large excel files getting generated in our application.... Could you send me one sample use of XLSCleaner in report design. Let me know which particular part of script we need to call this class function.
Thanks and Regards,
Muthul.
VijayMBS
<blockquote class='ipsBlockquote' data-author="'Raghava'" data-cid="78667" data-time="1308290617" data-date="16 June 2011 - 11:03 PM"><p>
I have been using BIRT2.6 for report generation. But Excel files which are generated by BIRT are huge in size(160 MB,50 MB).When I opened one Excel file using 'EditPlus' textpad, I noticed more than 80% size occupied by <strong class='bbc'>style tags</strong>. And if cell's data type is number then style id is being increased by 2 or 1 and new style tag is getting created with that Id.Usually one cell should use one style across all rows but it's not happening. It's causing duplicate style info and leading to huge size. Please find attached excel sheet for reference.<br /></p></blockquote>
<br />
Raghava,<br />
<br />
<a class='bbc_url' href='
https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806.'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806.</a>
; I just learnt that this was fixed in 3.7.1. Did you upgrade to fix this defect? <br />
<br />
Are you still facing the same issue after the upgrade?<br />
<br />
Incidentally, We are facing this issue. Our reports are massive upto 800MB. <br />
<br />
Did the zip file to clean the duplicate files in a cell from Jason work fix the defect?
Raghava
<blockquote class='ipsBlockquote' data-author="'VijayMBS'" data-cid="84645" data-time="1319798472" data-date="28 October 2011 - 03:41 AM"><p>
Raghava,<br />
<br />
<a class='bbc_url' href='
https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806.'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806.</a>
; I just learnt that this was fixed in 3.7.1. Did you upgrade to fix this defect? <br />
<br />
Are you still facing the same issue after the upgrade?<br />
<br />
Incidentally, We are facing this issue. Our reports are massive upto 800MB. <br />
<br />
Did the zip file to clean the duplicate files in a cell from Jason work fix the defect?<br /></p></blockquote>
<br />
Hi VijayMBS,<br />
<br />
I am still using Birt2.6.2 . Please go through below link for more info<br />
<a class='bbc_url' href='
https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806'>https://bugs.eclipse.org/bugs/show_bug.cgi?id=350806</a>
;
