Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Image in EXL2K
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Image in EXL2K
 Login/Join
 
Gold member
posted
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
 
Posts: 51 | Registered: August 31, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Waz - care to share?


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 51 | Registered: August 31, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Have you tried calling an excel macro to do this?
 
Posts: 4 | Registered: November 06, 2006Reply With QuoteReport This Post
<JG>
posted
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.
 
Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Image in EXL2K

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.