ExcelFileSummary 1.0

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : Freeware
CreatedCreated : Oct 2, 2007
Size downloadDownloads : 1
Program licensing
Thank you for voting...

[FILESTATS, RANGES] = EXCELFILESUMMARY(FILELOC)<br ...

[FILESTATS, RANGES] = excelfilesummary by Brett Shoelson(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 1.0('C:Documents and SettingsShoelsonBMy Documents est0046')
FILESTATS decription:
filename: name of file
location: absolute path
number: 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
Demands:
• MATLAB Release: R13

ExcelFileSummary 1.0 scripting tags: excelfilesummary, number, usedrange, file summary, sheet, structure, excel file, development tools. What is new in ExcelFileSummary 1.0 software script? - Unable to find ExcelFileSummary 1.0 news. What is improvements are expecting? Newly-made ExcelFileSummary 1.1 will be downloaded from here. You may download directly. Please write the reviews of the ExcelFileSummary. License limitations are unspecified.