Birt 4.4 Excel Emitter to single sheet excel export [message #1413242] |
Thu, 28 August 2014 06:16  |
Eclipse User |
|
|
|
I am trying to migrate from Birt 3.7 to 4.4. The excel export option in 4.4 exports the excel and creates a multitab excel based on the page break setting. But in version 3.7 it was coming properly in a single sheet.
My requirement is to get the excel export in to a single sheet.
Could you please help me with this?
Thanks
Sandeep
|
|
|
|
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1416001 is a reply to message #1415952] |
Thu, 04 September 2014 06:04   |
Eclipse User |
|
|
|
Thanks Michael for the response.
This will work, but my requirement is slightly different. I don't want to change anything at the report design level, as I am trying for a migration activity for 100+ reports. And when I export these reports to PDF, then I would need the page break so that it comes properly in multiple pages in pdf.
What I am looking for is something more centralized, like a property at the viewer level to specify if the export format is XLS/XLSX then export in to single sheet.
Thanks.
|
|
|
|
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1693474 is a reply to message #1416245] |
Fri, 24 April 2015 12:43   |
Eclipse User |
|
|
|
If you're using spudsoft emiiter, you can pass the option "__ExcelEmitter.SingleSheet". In my case, I change BirtExportReportDialog.js file to something like this:
if(format == "xls")
{
action = action + " &__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsEmitter&__ExcelEmitter.DisplayRowColHeadings=true&__ExcelEmitter.SingleSheet=true";
}
|
|
|
|
|
|
|
|
|
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1765159 is a reply to message #1413242] |
Wed, 07 June 2017 07:31   |
Eclipse User |
|
|
|
In order to avoid multi tab creation of records in excel sheet,set the page break interval correctly
1.In Outline ,select Body -->Table
2.In Properties,Select Advanced -->Page break Interval
Example:
If Page break Interval is set to 40, then after 40th record in table it migrates to next sheet.
|
|
|
Re: Birt 4.4 Excel Emitter to single sheet excel export- repeat header issue resolved. [message #1822435 is a reply to message #1413242] |
Fri, 06 March 2020 06:59   |
Eclipse User |
|
|
|
BIRT report does support xls or xlsx file download features. However for xlsx the downloaded file contains multiple sheets by default.
In order to change this to a single sheet put the below code in BirtExportReportDialog.js.
Method Name : __exportAction : function( )
if(format == "xlsx")
{
action = action + "&__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsxEmitter&__ExcelEmitter.SingleSheet=true&__ExcelEmitter.SingleSheetWithPageBreaks=true";
}
However this will fix the problem partially for xlsx file. Although it will create a single sheet excel file but the headers will be repeated after every 30/40 records which is a problem.
To over come this issue make the below changes in java file as excel Emitters does not support this feature. This is working for me.
Java File : ReportEngineService.java
Method Name : private IRenderTask createRenderTask (........)
if ( (!IBirtConstants.EXCEL_RENDER_FORMAT.equalsIgnoreCase( format )) && (!I"xlsx".equalsIgnoreCase( format ) ) )
{
( (IRenderOption) renderOption ).setOption( IRenderOption.HTML_PAGINATION, Boolean.TRUE );
}
This is tested and working fine.
|
|
|
Re: Birt 4.4 Excel Emitter to single sheet excel export- repeat header issue resolved. [message #1837357 is a reply to message #1822435] |
Thu, 28 January 2021 11:19  |
Eclipse User |
|
|
|
Hi Sandip,
I also have a similar issue and hope this thread can fix the issue.
I updated BirtExportReportDialog.js file as you mentioned, but I still see the data on different sheets on the xlsx file, it's 40 records on each page :(
Moreover, I could not find ReportEngineService.java file. Could you please let me know its path? I looked for it in org.eclipse.birt.report.viewer_4.3.1.v201309171028 and the entire birt folder.
Thank you in advance.
Regards,
Akanksha
|
|
|
Powered by
FUDForum. Page generated in 0.04730 seconds