Home
Analytics
How can i display image in excel using BIRT
ashish13
Hi,
I have to display image in my excel report using BIRT. how can i do the same.
Thanks in advance,
Ashish
Find more posts tagged with
Comments
mwilliams
Use the Tribix, Native Excel, or SpudSoft emitter plug-ins. They will work with open-source, BIRT and have more features than the standard XLS emitter. Let me know if you need links to any of these.
abhijitKol
I have tried using Tribix and spudsoft emitter.But chart/image is not coming when I export it in excel.
ashish13
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="99242" data-time="1334757434" data-date="18 April 2012 - 06:57 AM"><p>
Use the Tribix, Native Excel, or SpudSoft emitter plug-ins. They will work with open-source, BIRT and have more features than the standard XLS emitter. Let me know if you need links to any of these.<br /></p></blockquote>
<br />
Hi Jim,<br />
<br />
Thanks for the info. I am able to get the image using spudsoft and native excel emitter.<br />
<br />
Regards,<br />
Ashish
mwilliams
Ashish - I'm not Jim, but you're welcome!
abhijitKol - Are you sure you got the plug-ins for the other two installed correctly, because both of the ones you're saying don't work, definitely support images.
Yaytay
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="99247" data-time="1334758503" data-date="18 April 2012 - 07:15 AM"><p>
Ashish - I'm not Jim, but you're welcome!
<br />
<br />
abhijitKol - Are you sure you got the plug-ins for the other two installed correctly, because both of the ones you're saying don't work, definitely support images.<br /></p></blockquote>
<br />
mwilliams - Next time someone thanks me I'll get them to pass it on to you to even things out
.<br />
<br />
abhijitKol - If you're still having problems getting images from the SpudSoft emitter please let me know, either here or on <a class='bbc_url' href='
https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters'>BitBucket</a>.<br
/>
<br />
Jim
abhijitKol
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="99273" data-time="1334775044" data-date="18 April 2012 - 11:50 AM"><p>
mwilliams - Next time someone thanks me I'll get them to pass it on to you to even things out
.<br />
<br />
abhijitKol - If you're still having problems getting images from the SpudSoft emitter please let me know, either here or on <a class='bbc_url' href='
https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters'>BitBucket</a>.<br
/>
<br />
Jim<br /></p></blockquote>
<br />
Hi,<br />
I have used the native excel emitter.<br />
I have followed the following steps:<br />
1) Remove the following jars from the eclipse\plugin folder<br />
? org.eclipse.birt.report.engine.emitter.excel.config_2.6.2.r262_v20110127.jar<br />
? org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar<br />
2) Copy org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 into eclipse\plugin folder<br />
<br />
Now if i click on "View Report as XLS" option from eclipse,then I am able to see the image but when i call the report from a java page then image is not coming.<br />
<br />
Could anyone please help me. I need to deliver it to client.
abhijitKol
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99299" data-time="1334828608" data-date="19 April 2012 - 02:43 AM"><p>
Hi,<br />
I have used the native excel emitter.<br />
I have followed the following steps:<br />
1) Remove the following jars from the eclipse\plugin folder<br />
? org.eclipse.birt.report.engine.emitter.excel.config_2.6.2.r262_v20110127.jar<br />
? org.eclipse.birt.report.engine.emitter.prototype.excel_2.6.2.r262_v20110215.jar<br />
2) Copy org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 into eclipse\plugin folder<br />
<br />
Now if i click on "View Report as XLS" option from eclipse,then I am able to see the image but when i call the report from a java page then image is not coming.<br />
<br />
Could anyone please help me. I need to deliver it to client.<br /></p></blockquote>
Hi Jim,<br />
I have tried using SpudSoft emitter also.Buto not able to reproduce it when I call the report file from java environment. Could you please tell me the steps in detail..<br />
I am using Birt 3.7
Yaytay
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99300" data-time="1334828813" data-date="19 April 2012 - 02:46 AM"><p>
Hi Jim,<br />
I have tried using SpudSoft emitter also.Buto not able to reproduce it when I call the report file from java environment. Could you please tell me the steps in detail..<br />
I am using Birt 3.7<br /></p></blockquote>
Are you able to get to your image using any emitter from your Java application (i.e. try the PDF emitter)?<br />
Are you using the POJO engine (if you are using 3.7.0 or 3.7.1 you have to use the POJO engine, but 3.7.2 has the OSGi engine as an option (which you shouldn't choose unless you've got a good reason to)).<br />
<br />
I'm guessing that you don't have a correctly functioning ResourceLocator - getting that right is often neglected when setting up a BIRT engine application.<br />
There are built in ResourceLocators, but if you don't specify one at all you get something pretty useless (if I remember correctly).<br />
<br />
If you do have a ResourceLocator, can you check (either by debugging or logging) that it's finding the right image file?<br />
<br />
Jim
abhijitKol
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99300" data-time="1334828813" data-date="19 April 2012 - 02:46 AM"><p>
Hi Jim,<br />
I have tried using SpudSoft emitter also.Buto not able to reproduce it when I call the report file from java environment. Could you please tell me the steps in detail..<br />
I am using Birt 3.7<br /></p></blockquote>
<br />
I can see the Image if I export it in pdf format.But not in excel.if i click on "View Report as XLS" option from eclipse,then I am able to see the image but when i call the report from a java page then image is not coming.I don't know how to check ResourceLocator/POJO Engine. Could you please mention me the steps.
Yaytay
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99321" data-time="1334851713" data-date="19 April 2012 - 09:08 AM"><p>
I can see the Image if I export it in pdf format.But not in excel.if i click on "View Report as XLS" option from eclipse,then I am able to see the image but when i call the report from a java page then image is not coming.I don't know how to check ResourceLocator/POJO Engine. Could you please mention me the steps.<br /></p></blockquote>
<br />
If it works in PDF then it's probably not the ResourceLocator.<br />
So, another thought: what format is the image in?<br />
Try using a JPG file and see if that works.<br />
<br />
From memory (so might be wrong): JPG works in XLS and JPG and PNG work in XLSX.<br />
<br />
Jim
abhijitKol
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="99325" data-time="1334853131" data-date="19 April 2012 - 09:32 AM"><p>
If it works in PDF then it's probably not the ResourceLocator.<br />
So, another thought: what format is the image in?<br />
Try using a JPG file and see if that works.<br />
<br />
From memory (so might be wrong): JPG works in XLS and JPG and PNG work in XLSX.<br />
<br />
Jim<br /></p></blockquote>
I am using jpeg file.I think JPEG and JPG file are same.
abhijitKol
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99328" data-time="1334854973" data-date="19 April 2012 - 10:02 AM"><p>
I am using jpeg file.I think JPEG and JPG file are same.<br /></p></blockquote>
<br />
Hi,<br />
When i call the report from a java page,then the image is getting displayed in the BIRT report viewer but if I export it as excel from the BIRT report viewer window, then image is not getting exported in the excel file.
Yaytay
<blockquote class='ipsBlockquote' data-author="'abhijitKol'" data-cid="99328" data-time="1334854973" data-date="19 April 2012 - 10:02 AM"><p>
I am using jpeg file.I think JPEG and JPG file are same.<br /></p></blockquote>
I think so too.<br />
Time to get serious, can you post: <br />
<ul class='bbc'><li>A simple report that doesn't work for you (it needs to use either a scripted data set or the sample datasource so that I can run it)</li><li> The image that the report references</li><li> The output that you are getting from your Java environment</li></ul>
Amanke
I have added the jar org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 in my project but still me not able to view image in xls file after exporting report
Yaytay
<blockquote class='ipsBlockquote' data-author="'Amanke'" data-cid="113691" data-time="1359457778" data-date="29 January 2013 - 04:09 AM"><p>
I have added the jar org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114 in my project but still me not able to view image in xls file after exporting report<br /></p></blockquote>
Can you post your XLS file?<br />
Or can you say whether you get the warning about file type and extension from Excel when you open the file?<br />
<br />
Jim
Amanke
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="113709" data-time="1359484099" data-date="29 January 2013 - 11:28 AM"><p>
Can you post your XLS file?<br />
Or can you say whether you get the warning about file type and extension from Excel when you open the file?<br />
<br />
Jim<br /></p></blockquote>
Nope I don't get any warning but image is not displayed
Yaytay
<blockquote class='ipsBlockquote' data-author="'Amanke'" data-cid="113723" data-time="1359539469" data-date="30 January 2013 - 02:51 AM"><p>
Nope I don't get any warning but image is not displayed<br /></p></blockquote>
Are you able to create a simple report design and output Excel file that demonstrate the problem that you can post for us to take a look at?<br />
<br />
What kind of image is it (is it a resource or a chart, and if it's a resource is it embedded or external)?<br />
<br />
What file type is the image (jpg, png, etc)?<br />
<br />
How are you running the report (in Eclipse or in a report server, and what report server are you using)?<br />
<br />
Jim
Amanke
<blockquote class='ipsBlockquote' data-author="'Yaytay'" data-cid="113725" data-time="1359541241" data-date="30 January 2013 - 03:20 AM"><p>
Are you able to create a simple report design and output Excel file that demonstrate the problem that you can post for us to take a look at?<br />
<br />
What kind of image is it (is it a resource or a chart, and if it's a resource is it embedded or external)?<br />
<br />
What file type is the image (jpg, png, etc)?<br />
<br />
How are you running the report (in Eclipse or in a report server, and what report server are you using)?<br />
<br />
Jim<br /></p></blockquote>
Actually I am running report from the Firefox as I have integrated the reports with struts2.0.My file type is png and image is embedded
Yaytay
<blockquote class='ipsBlockquote' data-author="'Amanke'" data-cid="113727" data-time="1359541891" data-date="30 January 2013 - 03:31 AM"><p>
Actually I am running report from the Firefox as I have integrated the reports with struts2.0.My file type is png and image is embedded<br /></p></blockquote>
Are you able to create a simple report design and output Excel file that demonstrate the problem that you can post for us to take a look at?<br />
<br />
Jim
