Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: Added ShowPicture function (Read 2787 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: Added ShowPicture function
07.04.10 at 13:55:55
 
litLIB: Added ShowPicture function
 
The ShowPicture function was added to the litLIB functions library for Excel.  
 
ShowPicture displays an image from a file or from a website into a shape that is placed on top of the cell. A demonstration spreadsheet was created and attached to this topic so you can experiment with this function yourself.
 
The ShowPicture function is very easy to use. Simply type: =ShowPicture( "c:\myimage.png") to show the myimage.png file in the Excel cell.  
Another example.  

 
 
You can also use a url as a source for the image. Most browsers show a copy location menu when an image is right clicked. Simply use that as a parameter. For example =ShowPicture("http://www.google.com/intl/en_ALL/images/logo.gif") shows the google logo.
Another example:

 
A few exciting things can be done with the ShowPicture function as not only static images can be shown, dynamic images also work fine. For example you can show a stock chart from Yahoo:
=ShowPicture("http://ichart.finance.yahoo.com/instrument/1.0/%5EDJI/chart;range=1d/image;size= 239x110")

 
There also exist graphing facilities that you can use. The following graph was created using a php script call:
 

 
 
The ShowPicture function will be released in litLIB version 2.0.7
 
See also:
ShowPicture - litLIB help
http://www.oraxcel.com/projects/litlib/help/showpicture.html
litLIB release log
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1133444908
 
 
Back to top
« Last Edit: 07.04.10 at 14:01:13 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1