Images to display in Excel sheet

[pnvswamy]

Hi All ,

I am using jasper reports.It was fine .

Now i am facing problem in excel sheet for the image.

I want to generate a report and i want my company logo to place in the report .

Image is displayed to PDF,word formats and in Excel it is not coming

  If any one know please help me.

Code:

And i used the tag in Jrxml like below<image scaleImage="Clip" onErrorType="Icon" isLazy="true"><reportElement x="0" y="0" width="150" height="40"/><imageExpression class="java.lang.String"><![CDATA["http://jasperreports.sourceforge.net/jasperreports.png"]]></imageExpression></image>And in my java i used in 2 ways like 1) Using JExcelApiExporter---------------------------jrExporter = new JExcelApiExporter();/*JRXlsExporter();*/jrExporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);jrExporter.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);jrExporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);//jrExporter.setParameter(JExcelApiExporterParameter.IS_EMBEDDING_IMAGES, Boolean.TRUE);jrExporter.setParameter(JExcelApiExporterParameter.IS_IMAGE_BORDER_FIX_ENABLED,Boolean.TRUE);jrExporter.setParameter(JExcelApiExporterParameter.IS_IGNORE_GRAPHICS,Boolean.FALSE);  2).2nd way using JRXlsExporter ---------------------------------destFile = new File(ServletActionContext.getServletContext().getRealPath("reportDocs")+"/"+docFileName+".xls");jrExporter = new JRXlsExporter();jrExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);jrExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);jrExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

Post Edited by pnvswamy at 08/24/2010 03:20

[Teodor Danciu]

Hi,

 

Have you checked this?

http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html#FAQ26

 

I hope this helps.

Teodor