Linker IT Software
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: get WebPage Excel function (Read 2802 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
litLIB: get WebPage Excel function
05.01.08 at 23:55:36
litLIB: get WebPage Excel function
A new function was added to litLIB: WebPage(URL)
Using the WebPage function you can retrieve the HTML code of a webpage in Excel. Examples:
If you frequently visit web sites to get the latest information you can use this Excel function to let Excel collect it for you. I can think of the following examples: currency exchange info, stock market data, etc. I am sure you can think of other ones too! If you have another good example let me know.
Just use string functions to return the part of the string the contains the interesting info. I am working on a basic XPath query function so you can fetch part of the HTML that contains the interesting data.
This function will be released in litLIB 1.1.7
Back to top
« Last Edit: 05.01.08 at 23:58:09 by Gerrit-Jan Linker »  

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