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
引用格式
Brett Shoelson (2024). ExcelFileSummary (https://www.mathworks.com/matlabcentral/fileexchange/5692-excelfilesummary), MATLAB Central File Exchange. 检索来源 .
MATLAB 版本兼容性
平台兼容性
Windows macOS Linux类别
标签
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 |