Focal Point
[CLOSED] Image in EXL2K

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

November 02, 2011, 01:19 PM
Prash1983
[CLOSED] Image in EXL2K
Hi,

I want to embed images (NOT links) in my EXL2K report so that I can see the images when I am out of the network too (if I save the report file). Please help. Thanks!

This message has been edited. Last edited by: Kerry,


webFOCUS 7.6.x,
z/OS(Mainframes),
Excel and HTML
November 02, 2011, 04:51 PM
Waz
quote:
Don't ever say it can't be done !


Funny you should ask for this, as I have just created a utility that will add an image to EXL2K output.

But there are limitations.

1. The workbook must have multiple sheets.
2. The image shows in Excel 2003, 2010, but not in 2007.
3. The parts of the utility use Unix commands.
4. It only works for a held report, not returned to the browser.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 02, 2011, 05:02 PM
njsden
Wew! Thanks for saving me from an embarrassing moment Warren. Sweating I was going to say that it could not be done. Well, technically it can't be done exactly as most of us expect but you've proven us wrong. Smiler



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
November 02, 2011, 05:10 PM
Waz
It will be interesting to get the technique out there to see how it goes with the myriad of Excel verions


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 02, 2011, 05:17 PM
Glenda
Waz - care to share?


Glenda

In FOCUS Since 1990
Production 8.2 Windows
November 02, 2011, 05:30 PM
Waz
I'll desensify (Is that a real word?) the fexes and post the code and samples.


FYI

I've also only tested this on 7.1.6, 7.6.6 and 7.6.11, other versions may have issues with the technique.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 02, 2011, 05:52 PM
Prash1983
Thanks Waz! I am waiting for you to share the fex/logic... :-)

This message has been edited. Last edited by: Prash1983,


webFOCUS 7.6.x,
z/OS(Mainframes),
Excel and HTML
November 02, 2011, 06:01 PM
Waz
I'll see if I can prep it and post it tomorrow (my time).


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 02, 2011, 09:05 PM
njsden
Thanks in advance Waz. Smiler



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
November 03, 2011, 04:28 AM
Wayne
Have you tried calling an excel macro to do this?
November 03, 2011, 02:00 PM
<JG>
The solution can be completely driven by a macro / template.

I thought that I had posted a solution for this a couple of years ago but the post has disappeared and I cannot find the code.

Basically there are 2 options.

1st the images if static can be included in a 2nd worksheet and can be moved to the required location by a macro on open.
2nd the images are stored on the application server and the macro resolves and embeds the image on open.

You include macro code so that it only executes on 1st open. i.e. when opening the saved version it does not run the macro.

Quite a few good examples on the WWW.

I'll keep looking for my example.
November 03, 2011, 05:37 PM
Waz
For those that may be interested, I have made available the programs and samples..

http://forums.informationbuild...067021216#3067021216


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 03, 2011, 05:53 PM
njsden
Thanks Waz. I'll try to devote some time to analyze those. I'm sure there will be more than a few gems buried in there.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
November 03, 2011, 06:00 PM
Waz
Hopefully not too many bombs, it was thrown together quite quickly.

Big Grin


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

November 03, 2011, 07:05 PM
njsden
I'll be prepared!



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.