support exporting images displayed in Excel?

[fadeli1]

birt: 4.9.0

There is a dynamic picture, which is assigned by fields in the dataset
Field Type: blob

Export PDF display images.
No pictures are displayed when you export Excel.
Does Excel support image export?

[speckyspooky]

Hello fadeli1,

yes it is an standard feature of BIRT and exists already before BIRT 4.9, therefore it could nice to know you explicit case.
I created a very small report example based on the care model with dynamic image and exported it to PDF, XLSX, Excel (XLS) - see my screen.

Please be aware the handling of images in excel is tricky because the size of the image can be set in differnt ways
with the own hight-width settings or one of the tricks is the rounding with an own framing grid (size 1col x 1row).

Best regards

cars_test.zip

[fadeli1]

I changed from dynamic images to embedded images, exported pdf to display images, exported excel to not display images

Could it be that the Excel dependency JAR package was not imported?

[speckyspooky]

Can you get us more information about your BIRT version and do you ue the eclipse-all-in-one or rcp-designer-version?
BIRT use the excel-spudsoft-emitter to create Excel & XLSX.

My suggestion for you is to download one of the new BIRT versions 4.9 or 4.10 and try my test-report to test the excel result.

Currently I use different BIRT Versions which works perfect with Excel & images:

• BIRT 4.6 & 4.8, Java 8 - I added 2 screens of my excel-spudsoft-plugins
• BIRT 4.9 & 4.10, Java 11

[fadeli1]

I use https://download.eclipse.org/birt/downloads/drops/R-R1-4.9.0-202203161719/birt-runtime-4.9.0-20220315.zip

[speckyspooky]

Could you please add an example of your report without external data sources but with your image-mechanism.
In best case an image of your excel result and pdf result to compare. So we are able to understand your target and implementation.
And so perhaps we can solve your issue together.

Currently what I not understand correctly try you to ad only images on excel together with data
or try you to implements excel-background-images or what is your target with the images on excel?

[858882847]

您能否添加一个没有外部数据源但使用图像机制的报表示例。在最好的情况下，您的 excel 结果和 pdf 结果的图像进行比较。因此，我们能够了解您的目标和实施情况。因此，也许我们可以一起解决您的问题。

目前我无法正确理解的是，尝试您仅将 excel 上的图像与数据一起广告，或者尝试实现 excel 背景图像，或者您对 excel 上的图像的目标是什么？

test.zip

[858882847]

您能否添加一个没有外部数据源但使用图像机制的报表示例。在最好的情况下，您的 excel 结果和 pdf 结果的图像进行比较。因此，我们能够了解您的目标和实施情况。因此，也许我们可以一起解决您的问题。

目前我无法正确理解的是，尝试您仅将 excel 上的图像与数据一起广告，或者尝试实现 excel 背景图像，或者您对 excel 上的图像的目标是什么？

The pdf file is an xls file with images. There are no images. xlsx has some images, but the format is disordered. The data is also disordered. It should be a bug

[858882847]

Uploading test.zip…

[858882847]

您能否添加一个没有外部数据源但使用图像机制的报表示例。在最好的情况下，您的 excel 结果和 pdf 结果的图像进行比较。因此，我们能够了解您的目标和实施情况。因此，也许我们可以一起解决您的问题。

目前我无法正确理解的是，尝试您仅将 excel 上的图像与数据一起广告，或者尝试实现 excel 背景图像，或者您对 excel 上的图像的目标是什么？

speckyspooky: Did you receive the file

[hvbtup]

Could you please add an example of your report without external data sources but with your image-mechanism.

What speckyspooky means is: please attach an rptdesign file that others can test and which demonstrates the problem; not only the output.

[speckyspooky]

So I checked your demo-file and figured out the issue.
You use the "text"-element, configured it to HTML and used th img-tage to add the image.

This isn't the default usage of images for excel because currently the excel-Emitter doesn't support data-URL.
The data-URL will be supported currently only at the print outputs like DOCX, PDF, HTML, PPTX.

Therefore I added 2 additional cases in my demo report and the XLSX-result attached.
The effect ist for example to use embedded images on BIRT-level with the image-element
and a second BIRT-image element where I use a 2 line script (please take a look into the advanced-properties) to select your Base64-string and put it to an BIRT-image.

Please be aware I changed your scripted data set on your images to base64 & data-URL.
I hope it will help you a littel bit.

test_20230317.zip

[858882847]

"When I debug, the xls cell is normal, and the xlsx cell is chaotic."

[speckyspooky]

This isn't chaotic. The important thing is XLS is dead because it is the very old format of excel.
The supported Microsoft format is XLSX.

The XLS file type are completely different from XLSX because XLSX is only a zip file which includes all media files in raw (like real images) and according of it the data like XML files and according style information.
Therefore you cannot compare these file types directly.

Additonal on it based on history there are 3 ways for excel:

• XLS "Excel" without spudsoft (orgininal emitter) - lowest support and functionality
• XLS "Spudsoft excel" which was sponsored from Spudsoft company to the project - standard support (but not with all features)
• XLSX "Spudsoft excel" which was sponsored from Spudsoft company to the project - standard support (but not with all features)

The both Spudsoft-excels have the same core base of implementation but the emitters are different and based on an external library wich is called apache POI.

The best way for you is to use XSLX of Spudsoft. Please be aware the excel outputs are relay good to export data but the output of formatted styled documents are very tricky because it isn't a layout optimized output it is optimized for data.

[858882847]

These two are from the same birt file. The first is xls, and the second is xlsx. Why does this happen? Is this a background configuration issue for me? Can it be resolved

[speckyspooky]

Please be aware your uestion on this discussion was, is it possible to but images to excel files.
The answer from our side is yes and I got you an example. So please start a new discussion if you have new question on excel.

The target is to avoid topic mix so that we can reference to this discussion on same topics.

Short comment to your new note, no there is no background issue.
Like my comment before we have2 options to create excel and you didn't write it.
There are many ways to optimize excel/xlsx output and so this isn't be default an issue/bug.

Please start a new discusssion if you cannot solve your issue e.g. with column-width-settings to get the same width.
And add an example without data source and chinese display names because I had to change a lot to get your test example runable.

[858882847]

xlsx
Have you ever tried storing images in a merge grid

[858882847]

[wimjongman]

This discussion is closed. Please open a new one.