| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3DynamicPicture"
| Line 1: | Line 1: | ||
Updates a Picture or Pictures to an image on the internet. | 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. | ||
==Syntax== | ==Syntax== | ||
Revision as of 16:14, 22 July 2011
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.
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. |
