How to get SpudSoft excel emitter to work with BIRT 4.3.0.2

I am using BIRT 4.3.02. and I have Excel 2010 installed on my machine.
 
When I output my report in excel, the file is saved with a .xls extension as type "Microsoft Excel 97-2003 Worksheet". (I don't understand why it would do this?)
 
I am using Grails and have added this to my code to try and get it to use the SpudSoft emitter that comes with this version of BIRT:
 
case "xls": 
excelOptions.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); 
excelOptions.setOutputFormat("xls_spudsoft");
 
I would really appreciate any ideas.
 
Thank you.

Find more posts tagged with

Comments

bugsy

I have been doing some more research and have replaced my above code with this:
 
RenderOption excelOptions = new RenderOption(); 
if ("XLS".equalsIgnoreCase(ext)) { 
excelOptions.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter"); 
} else if ("XLSX".equalsIgnoreCase(ext)) { 
excelOptions.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsxEmitter"); 
}
 
My file is still generated as type "Microsoft Excel 97-2003 Worksheet". I would love to know why this is happening.
 
However, it appears that is is using spudsoft since I am no longer getting the "file you are trying to open is in a different format than specified by the file extension" message.
 
My report design has a Table with a single row. The row has a single cell which contains one grid and three tables. The grid and first two tables don't even show up in the excel file. I get an empty sheet. A second sheet is created for the third table but everything is displayed in a single column.
 
The pdf generates fine.
 
Any ideas appreciated. Thanks.