| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3DynamicPicture
Updates a Picture or Pictures to an image on the internet.
This allows you to display an Picture based on a parameter in Excel. For example if a report is driven by a Store parameter, you could use this to display a picture of the store.
This function is primarily for use in reports published to the web where images update automatically. In Excel you can force a refresh of the images by using the XLCubed -> Extra -> Refresh Dynamic Pictures menu option (please note this will only retrieve a new picture in Excel if the formula has run in the current session and had a different URL to the last run)
Contents
[hide]Syntax
XL3DynamicPicture( PictureName, Url )
Parameters
| Parameter | Description |
|---|---|
| PictureName | Name of the Picture to update. If several Pictures have the same name they will all be updated. |
| Url | Web address of the image to use, in the form http://www.example.com/logo.jpg. |
Example
You can setup a named image by inserting a picture using the standard Excel menu option.
Next set the Picture name by right-clicking it, and selecting properties. The name goes in the "Alt Text" box.
Finally set up a formula, e.g.
=XL3DynamicPicture("MyLogo"; "http://www.example.com/logo.jpg")
Here the Url paramater is fixed, but it could be set to reference another cell or concatenated text.
Scheduling/PDF
For dynamic pictures in reports that are going to be scheduled or downloaded as PDFs/Workbooks, the URL will need to be for a server that is accessible from the XLCubedWeb server and doesn't required any authentication. So a internet site URL is fine if the server has internet access, or a local server would be OK if that was setup to allow Anonymous access.
