nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

crosstab export to excel

Birtsnew

Hi,

I have a report with four cross tabs inside the grid.i am trying to export to excel.but every crosstab is breaking separately in excel,it's rendering properly in html.

I am using below plugins for export excel.
1.org.uguess.birt.report.engine.emitter.xls_2.5.1
2.org.uguess.birt.report.engine.common_1.1.1.201001221050.jar

Attached the excel export and html output also.

Please let me know, is any to solve the pagebreak in excel export.

Thanks in advance
sam.

Find more posts tagged with

Comments

Birtsnew

Hi,

i fixed the issue.

Sam.

csj

please check following...The following code will identify the address of any horizontal page breaks in a worksheet (replace H with V for vertical page breaks). You should be able to use this to identify the separate ranges to copy. 
 
Code: 
 
Sub PBreaks() 
 
Dim pbrk As HPageBreak 
 
For Each pbrk In ActiveSheet.HPageBreaks 
Debug.Print pbrk.Location.Address 
Next 
 
End Sub 
 
 
 
 
 
 
 
<blockquote class='ipsBlockquote' data-author="'Birtsnew'" data-cid="77660" data-time="1306489265" data-date="27 May 2011 - 02:41 AM">
Hi, 
 
I have a report with four cross tabs inside the grid.i am trying to export to excel.but every crosstab is breaking separately in excel,it's rendering properly in html. 
 
I am using below plugins for export excel. 
1.org.uguess.birt.report.engine.emitter.xls_2.5.1 
2.org.uguess.birt.report.engine.common_1.1.1.201001221050.jar 
 
Attached the excel export and html output also. 
 
Please let me know, is any to solve the pagebreak in excel export. 
 
Thanks in advance 
sam. </blockquote>