Eclipse Community Forums: BIRT » Large data export to XLSX format

Home » Archived » BIRT » Large data export to XLSX format(Showing warning messages when large data export to XLSX format)

Show: Today's Messages :: Show Polls :: Message Navigator

Large data export to XLSX format [message #1753479]

Mon, 06 February 2017 22:52

Srinivas Narra

Messages: 5
Registered: February 2017

Junior Member

Hi,

Getting below popup message when we export report to XLSX format.
This is happening only if the number of records are more.

We found a problem with some content in 'filename.xlsx' Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

Added below code after line number 110, to get all data in single sheet 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";
}
Attached sample report with ClassicModels. Please let me know how to remove this popup message.

Birt version tested in 4.5 and 4.6

Thanks,
Narra

Attachment: XlsxExportTest.rptdesign
(Size: 32.02KB, Downloaded 318 times)

Report message to a moderator

Re: Large data export to XLSX format [message #1753837 is a reply to message #1753479]

Fri, 10 February 2017 14:54

Srinivas Narra

Messages: 5
Registered: February 2017

Junior Member

Found workaround for this issue

1) Set report layout preference to 'Auto Layout'
2) Set tables page break property to 0 and uncheck 'Repeat Header'

After the above changes, export to xlsx is working fine and not giving any warning popup messages.

Thanks,
Narra.

Attachment: XlsxExportTest.rptdesign
(Size: 31.90KB, Downloaded 329 times)

Report message to a moderator

Previous Topic:	How to use Excel IQY query as data set in Birt
Next Topic:	Memory Leaks when report contains hidden table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 25 01:03:09 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter