Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Birt 4.4 Excel Emitter to single sheet excel export(Excel Emitter is creating multiple sheets based on the page break, this is different from how it was in 3.7 emitter)
Birt 4.4 Excel Emitter to single sheet excel export [message #1413242] Thu, 28 August 2014 02:16 Go to next message
Eclipse UserFriend
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 #1415952 is a reply to message #1413242] Wed, 03 September 2014 23:05 Go to previous messageGo to next message
Eclipse UserFriend
Set your report layout to auto in the property editor and make sure you don't have your page break values for your tables set to 0. Let me know if this helps.
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1416001 is a reply to message #1415952] Thu, 04 September 2014 02:04 Go to previous messageGo to next message
Eclipse UserFriend
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 #1416245 is a reply to message #1416001] Thu, 04 September 2014 13:04 Go to previous messageGo to next message
Eclipse UserFriend
I think the standard XLS still works the way you're wanting. The XLS_Spudsoft and XLSX do the page breaking. These are both from the Spudsoft Excel Emitters project.

You could set the page break interval based on your output format, but you'd have to modify each report to do so.
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1693474 is a reply to message #1416245] Fri, 24 April 2015 08:43 Go to previous messageGo to next message
Eclipse UserFriend
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 #1694663 is a reply to message #1693474] Wed, 06 May 2015 22:02 Go to previous messageGo to next message
Eclipse UserFriend
Thanks Gesiel da Silva.
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1718714 is a reply to message #1693474] Tue, 29 December 2015 07:01 Go to previous messageGo to next message
Eclipse UserFriend
May I know what is the case for the xlsx.

Is this correct code
if( format=="xlsx" )
{
action = action + "&__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsEmitter&__ExcelEmitter.DisplayRowColHeadings=true&__ExcelEmitter.SingleSheet=true";
}

I tried this is not working
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1718717 is a reply to message #1693474] Tue, 29 December 2015 07:18 Go to previous messageGo to next message
Eclipse UserFriend
for xls by default it is working fine but for xlsx it is giving multiple sheets.Please suggest
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1718915 is a reply to message #1694663] Sat, 02 January 2016 05:42 Go to previous messageGo to next message
Eclipse UserFriend
Refer this link as well
birtworld.blogspot.in/2011/07/replacing-default-birt-xls-emitter
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1720101 is a reply to message #1718915] Thu, 14 January 2016 06:59 Go to previous messageGo to next message
Eclipse UserFriend
Thanks
It worked i moved jar in the lib folder .I got in the Single sheet

if( format=="xlsx" )
{
action = action + "&__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsxEmitter&__ExcelEmitter.DisplayRowColHeadings=true&__ExcelEmitter.SingleSheet=true";

}
Re: Birt 4.4 Excel Emitter to single sheet excel export [message #1751183 is a reply to message #1720101] Thu, 05 January 2017 08:29 Go to previous messageGo to next message
Eclipse UserFriend
Hi.... Jagannath,

Could u pls tell where do I need to add this code

if( format=="xlsx" )
{
action = action + "&__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsxEmitter&__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 03:31 Go to previous messageGo to next message
Eclipse UserFriend
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 01:59 Go to previous messageGo to next message
Eclipse UserFriend
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 06:19 Go to previous message
Eclipse UserFriend
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
Previous Topic:Export BIRT report to xlsx format in single page
Next Topic:Reports Run Multiple Times
Goto Forum:
  


Current Time: Sat Mar 22 06:20:39 EDT 2025

Powered by FUDForum. Page generated in 0.10313 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly