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; } } }

Export to Excel issue in Birt Report viewer

rajag

Using BIRT Report 2.5/ BIRT Viewer application (org.eclipse.birt.report.engine.ReportEngineSDK) 
 
We are able to view the report in html and export to pdf working fine. 
 
Export to Excel creates the excel file when I open the excel file it shows error. I am attaching the report and excel file. 
 
We opened the excel file in the notepad and if I remove the below Cell 
 
<Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="11" ss:MergeDown="0"> 
<Data ss:Type="String"/> 
</Cell> 
 
It works fine we don't know where it is generating the following cell. Please help me. 
 
I am finding difficutly to upload the excel document. I paste the content of the excel below. 
 
 
<?xml version="1.0" encoding="UTF-8"?> 
<?mso-application progid="Excel.Sheet"?> 
 
 
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="<a class='bbc_url' href='http://www.w3.org/TR/REC-html40">'>http://www.w3.org/TR/REC-html40"></a> 
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> 
<Author>Raja Gopalan</Author> 
<Title>Agent Statistics</Title> 
<Description/> 
</DocumentProperties> 
<Styles> 
<Style ss:ID="HyperlinkId" ss:Name="Hyperlink"> 
 
</Style> 
<Style ss:ID="27"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom"/> 
<Border ss:Position="Top"/> 
<Border ss:Position="Left"/> 
<Border ss:Position="Right"/> 
</Borders> 
 
</Style> 
<Style ss:ID="1"> 
<NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM"/> 
</Style> 
<Style ss:ID="23"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom"/> 
<Border ss:Position="Top"/> 
<Border ss:Position="Left"/> 
<Border ss:Position="Right"/> 
</Borders> 
 
</Style> 
<Style ss:ID="21"> 
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom"/> 
<Border ss:Position="Top"/> 
<Border ss:Position="Left"/> 
<Border ss:Position="Right"/> 
</Borders> 
 
</Style> 
<Style ss:ID="22"> 
<Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom"/> 
<Border ss:Position="Top"/> 
<Border ss:Position="Left"/> 
<Border ss:Position="Right"/> 
</Borders> 
 
</Style> 
<Style ss:ID="24"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
</Borders> 
 
</Style> 
<Style ss:ID="26"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
</Borders> 
 
<NumberFormat ss:Format="Percent"/> 
</Style> 
<Style ss:ID="25"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#cccccc"/> 
</Borders> 
 
<NumberFormat/> 
</Style> 
<Style ss:ID="20"> 
<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> 
<Borders> 
<Border ss:Position="Bottom"/> 
<Border ss:Position="Top"/> 
<Border ss:Position="Left"/> 
<Border ss:Position="Right"/> 
</Borders> 
 
</Style> 
</Styles> 
<Worksheet ss:Name="Sheet1"> 
<ss:Table> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="48"/> 
<ss:Column ss:Width="0"/> 
<Row ss:AutoFitHeight="0" ss:Height="66.0"/> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="21" ss:MergeAcross="11" ss:MergeDown="0"> 
<Data ss:Type="String">Agent Statistics</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="11" ss:MergeDown="0"> 
<Data ss:Type="String">5/1/2011 to 5/2/2011</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="11" ss:MergeDown="0"> 
<Data ss:Type="String"/> 
</Cell> <Cell ss:Index="3" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">ACD Contacts</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Total ACD Time</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Avg ACD Dur</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Total OB Time</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Available Time</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Unavail Time</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Total Time</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Working Rate</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Active Rate</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Unavail Rate</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="2"> 
<Data ss:Type="String">Test01,dPi (50141)</Data> 
</Cell> 
<Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">05/01/2011</Data> 
</Cell> 
<Cell ss:Index="3" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:09</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:05:10</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:05:19</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">1.0</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.02821316614420063</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.0</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">05/02/2011</Data> 
</Cell> 
<Cell ss:Index="3" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:17:41</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:02</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:17:43</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.9981185324553151</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.0</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.0018814675446848542</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Agent Totals:</Data> 
</Cell> 
<Cell ss:Index="3" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:22:51</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:02</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:23:02</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.9985528219971056</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.006512301013024602</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.001447178002894356</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="1"> 
<Data ss:Type="String">Test02,dPi (50142)</Data> 
</Cell> 
<Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">05/02/2011</Data> 
</Cell> 
<Cell ss:Index="3" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">13</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:01:28</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:06</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">04:03:08</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">04:04:36</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">1.0</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.005996184246388662</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.0</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">Agent Totals:</Data> 
</Cell> 
<Cell ss:Index="3" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">13</Data> 
</Cell> 
<Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:01:28</Data> 
</Cell> 
<Cell ss:Index="5" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:06</Data> 
</Cell> 
<Cell ss:Index="6" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">04:03:08</Data> 
</Cell> 
<Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">00:00:00</Data> 
</Cell> 
<Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="String">04:04:36</Data> 
</Cell> 
<Cell ss:Index="10" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">1.0</Data> 
</Cell> 
<Cell ss:Index="11" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.005996184246388662</Data> 
</Cell> 
<Cell ss:Index="12" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> 
<Data ss:Type="Number">0.0</Data> 
</Cell> 
</Row> 
<Row ss:AutoFitHeight="0" ss:Height="15.0"> 
<Cell ss:Index="1" ss:StyleID="27" ss:MergeAcross="11" ss:MergeDown="0"> 
<Data ss:Type="String">May 18, 2011 8:44 PM</Data> 
</Cell> 
</Row> 
</ss:Table> 
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> 
<PageSetup/> 
</WorksheetOptions> 
</Worksheet> 
</Workbook>

Find more posts tagged with

Comments

JasonW

This looks like a bug. Have you tried the report in the latest version of BIRT? Can you try putting a label in the top left hand cell of the crosstab. I do not know if it will change anything but may be worth a try. Look at the attached image.

Jason

JasonW

Also if you delete everything (make a copy) but just the crosstab do you get the error?

Jason

rajag

I tried adding label first and it didn't work then I added grid and label no luck.

Using eclipse birt is there any way to preview the excel report?

JasonW

Not sure what you mean but you can run directly to xls using the toolbar icon and select "View Report as XLS". As a test can you try this in BIRT 2.6.2?

Jason

rajag

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="77236" data-time="1305824854" data-date="19 May 2011 - 10:07 AM">
Not sure what you mean but you can run directly to xls using the toolbar icon and select "View Report as XLS". As a test can you try this in BIRT 2.6.2? 
 
Jason </blockquote>
 
 
Thanks I got it. 
 
My question was is there anyway to run the report by using the Birt viewer to generate the Excel document. 
 
Before I use to drop the report to my reportviewer applicaiton and to see the excel export.

rajag

Yes...

by removing all other and left the cross tab it works fine.

JasonW

I am not sure what is causing this. You may want to log a bug for it.

Jason

rajag

I am new for this can you guide me how to do that?

rajag

And again I am not using the newer version of birt. And sometime we are getting timeout where the timeout was configured in birt?

JasonW

Look at the bugzilla entry on this page:
http://www.eclipse.org/birt/phoenix/community.php

What timeout error are you getting?

Jason

kallem

If you want to dig into problem you may download <a class='bbc_url' href='http://download.eclipse.org/birt/downloads/build.php?build=R-R1-2_6_2-201102191842'>Birt source code</a> and start looking the Excel emitter to find out why this one cell gets the ss:MergeAcross="11" value. Inside Excel emitter ExcelXmlWriter.java is a good place to start. Then just replace the original Excel emitter with the modified. As emitters are in separate jars it is quite easy to modify them.