ExcelFileSummary
[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
shoelson@helix.nih.gov
8/12/04
Cite As
Brett Shoelson (2024). ExcelFileSummary (https://www.mathworks.com/matlabcentral/fileexchange/5692-excelfilesummary), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |