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: FileContents function as array function (Read 1546 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: FileContents function as array function
13.12.09 at 22:13:01
 
litLIB: FileContents function as array function
 
The FileContents function in the litLIB power functions library for Excel has been extended. Hitherto this function could be used as a cell function only retrieving up to some 30.000 bytes from file into the cell.
 
While this functionality remains unchanged we extended the use of this function. Array function functionality has been added. If you select one column and multiple rows as a cell range, then enter the formula and press Ctrl+Shift+Enter it will return in each cell a line from the file. This could be handy while procesing text files.
 
Try it on a log file for example. A file most people will have in their windows folder: WindowsUpdate.log. The following formula will show the first 10 lines of the file, each in its own cell:
Select A1:A10. Type the formula =FileContents("c:\windows\WindowsUpdate.log") Then press Ctrl+Shift+Enter.
Voila.
 
See also:
FileContents
http://www.oraxcel.com/projects/litlib/help/filecontents.html
Back to top
 
 

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