ExcelFileSummary

Provides a description of an Excel file, and optionally returns all used ranges of the file.

[FILESTATS, RANGES] = EXCELFILESUMMARY(FILELOC)

FILELOC: Enter the absolute path/name to the file you want to examine

FILESTATS: output argument will be a structure describing the file

RANGES: If this optional output variable is provided, the function will also return a structure containing the entire used range of each sheet.

Example:

[filestats, contents] = excelfilesummary('C:\Documents and Settings\ShoelsonB\My Documents\test0046')

FILESTATS decription:

filename: name of file
location: absolute path
number_of_sheets: number of sheets
active_sheet: index of currently active sheet
sheetnames: sequential sheet labels
blocksize: number of rows and columns currently used, by sheet
usedrange: Excel address of used range (Ex: {['A1', 'F21']})
usedcolrow: Column/row indices corresponding to usedrange (Ex: {[1,6],[1,21]})

ALSO: structures containing more information than you ever wanted to know about the application (Application_Info), the workbook (Workbook_Info), the individual sheets (sheet_properties), and the usedrange in each sheet (usedrange_properties)

CONTENTS:
Output: structure containing a cell array of spreadsheet contents for each sheet in the file

Written by Brett Shoelson, PhD
[e-mail]
8/12/04