Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Filesystem functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - FileContents funtion
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

File System - FileContents

Syntax:
=FileContents(File [, StartPosition])

Description:
Returns the contents of a file. If the file is large only the first 32,000 characters are returned. Optionally the StartPosition parameter can be given to return 32,000 characters starting at a specific offset position.

File : Full name and path of the file

StartPosition : Byte offset position from where the filecontents should be shown.

Example:
=FileContents("c:\myfile.txt")
=FileContents("c:\myfile.txt", 50000)

litLIB