ExcelFileSummary 1.0

[FILESTATS, RANGES] = EXCELFILESUMMARY(FILELOC)FILELOC: Enter the absolute path/name to the file you want to examineFILESTATS: output argument will be a structure describing the fileRANGES: 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 SettingsShoelsonBMy Documentstest0046')FILESTATS decription:filename: name of filelocation: absolute pathnumber_of_sheets: number of sheetsactive_sheet: index of currently active sheetsheetnames: sequential sheet labelsblocksize: number of rows and columns currently used, by sheetusedrange: 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 fileWritten by Brett Shoelson, PhDshoelson@helix.nih.gov8/12/04

Requirements:	No special requirements
Platforms:	Matlab
Keyword:	039a1039,  Address,  Array,  Columnrow,  Columns,  Excel,  Indices,  Information,  Labelsblocksize,  Sequential,  Sheet,  Sheetusedrange,  Spreadsheet,  Structures,  Usedcolrow,  Usedrange,  Usedrange Propertiescontentsoutput,  Wanted
Users rating:	0/10