Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Show Data in One Excel Tab(Show Data in One Excel Tab)
Show Data in One Excel Tab [message #1750870] Fri, 30 December 2016 13:05 Go to next message
Mr Data is currently offline Mr DataFriend
Messages: 2
Registered: December 2016
Junior Member
Hi,

How can we get BIRT's data in one EXCEL sheet in BIRT 4.6.0.v2 ?

I set up 40 rows in pagebreak intervals. I should see data as 40 rows in html but I need to show data in one Excel sheet.

BIRT seperates the data into multiple tabs.

reportContext.getOutputFormat() function always shows HTML. So I could not use function.

Regardingly,

Re: Show Data in One Excel Tab [message #1753856 is a reply to message #1750870] Fri, 10 February 2017 18:14 Go to previous messageGo to next message
Srinivas Narra is currently offline Srinivas NarraFriend
Messages: 5
Registered: February 2017
Junior Member
Add below code after line number 110, to get all data in single sheet/tab in BirtExportReportDialog.js file(..\plugins\org.eclipse.birt.report.viewer_4.6.0.v201606072122\birt\webcontent\birt\ajax\ui\dialog)
if( format=="xlsx" )
{
action = action + "&__emitterid=uk.co.spudsoft.birt.emitters.excel.XlsxEmitter&__ExcelEmitter.DisplayRowColHeadings=true&__ExcelEmitter.SingleSheet=true";
}

In tables 'Page Break' property, uncheck 'Repeat Header' checkbox to show headers only one time in xlsx file.

Thanks,
Narra
Re: Show Data in One Excel Tab [message #1801127 is a reply to message #1753856] Mon, 14 January 2019 11:23 Go to previous message
venkatesh veera is currently offline venkatesh veeraFriend
Messages: 4
Registered: November 2018
Junior Member
Hello Srinivas ,
i have similar Problem as Mr data But my Code is in Java(EngineApi). Can you Please tell how to Add Multiple Sheet In Excel (xlsx) Using Birt and Put Data Into Excel Sheet. As per My requirement i need one Table In each Sheet

[Updated on: Thu, 17 January 2019 14:28]

Report message to a moderator

Previous Topic:Preview Tab Missing In Designer
Next Topic:Report parameter combo box not populating #2
Goto Forum:
  


Current Time: Tue Jul 16 07:55:52 GMT 2019

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

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

Back to the top