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 demo: Cockpit spreadsheet (Read 2857 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB demo: Cockpit spreadsheet
16.08.08 at 16:33:30
 
litLIB demo: Cockpit spreadsheet
 
To show how easy it is to make a cockpit spreadsheet I have created this topic and attached the demo spreadsheet: cockpit.xls.
 
I wanted to create a cockpit showing the current stock market indexes, the free space on my C drive and my PC's free memory.
 

 
To retrieve the infomation from a webpage the =Webpage function is used. On the site www.beurs.nl the main world indexes are found:
=WebPage("http://www.beurs.nl")
Using the string functions Instr and Mid I retrieve the value. Converting it to a number the ToDouble function was used.
 
To get the number of free bytes on the C drive the DiskFreeBytes function was used. The memory status was displayed using the MemoryTotal, MemoryFree and MomoryUsed functions.
Back to top
« Last Edit: 16.08.08 at 16:41:19 by Gerrit-Jan Linker »  

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