Focal Point
[SOLVED] Embedding Images into Excel Cells

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5857083196

June 26, 2019, 10:53 AM
John_Edwards
[SOLVED] Embedding Images into Excel Cells
So, I have a table that I'm trying to send to Excel. Easy Peasy. The first seven columns are text and all is working well. It's a time series table where each column represents a week of data.

The next column is a graphical display of the prior columns' data, a little baby line graph.

As of right now I have the WF routine producing all of the graphs as images and saving them off in the ibi_html directory structure. So I can run to html as sweet as you please, the graphs link and everything looks great. But I want to have the output go to EXL2K or EXL07 and the result is that I get the little red X in the Excel cells for the images that indicate the "linked image cannot be displayed".

Can anyone tell me how to have the images embedded directly in the excel spreadsheet, or linkable so that they appear? Currently my link to the image in the TABLE FILE request is this --

SPARKLINE_NAME/A200V = '<img src="/ibi_html/images/sparklines/6_wk_branch_spark_' | UNIT_NO_SPACE || '_all_svcs_wait_time.png" >';

This message has been edited. Last edited by: FP Mod Chuck,



June 26, 2019, 05:32 PM
Waz
My first guess is that the link is relative, not absolute.

Can you add in the domain name and protocol ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 27, 2019, 09:22 AM
John_Edwards
quote:
Originally posted by Waz:
Can you add in the domain name and protocol?


Dude! That's the ticket! I made that one simple change and it popped into place.

The next round is on me.

"If it wouldn't be a waste of such a damn fine enlisted man, I'd recommended you for OCS!"



June 27, 2019, 04:57 PM
Waz
Glad I could help.

Make mine a stout


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!