About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 5 years ago
  • Total downloads: 57
  • Price: Free |
  • Operating system: Linux, Mac OS X, Win All, BSD, Solaris
  • Publisher: Brett Shoelson (32 other programs)
See full specifications

scripts default iconExcelFileSummary (Scripts) Publisher's description



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

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.


[filestats, contents] = excelfilesummary('C:Documents and SettingsShoelsonBMy Documentstest0046')

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)

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

Written by Brett Shoelson, PhD

System Requirements:

MATLAB 6.5 (R13)
Program Release Status: New Release
Program Install Support: Install and Uninstall

Is ExcelFileSummary (Scripts) your software?

Manage your software

Most Popular

scripts default icon ASK, OOK, FSK, BPSK, QPSK, 8PSK modulation 1.1
ASK, OOK, FSK, BPSK, QPSK, 8PSK modulation contain several functions for digital modulation simulation
scripts default icon Simulink Communication Labs 1.1
Simulink Communication Labs allows you to learn communication systems in greater depth.
scripts default icon M-QAM modulation and demodulation 1.1
M-QAM modulation and demodulation is the QAM modulation and demodulation tech.
scripts default icon LZW Compression/Decompression 1.1
LZW Compression/Decompression - Updated LZW compressor and decompressor with reasonable performance
scripts default icon InSPIRE utility to plot a 2D displacement field (Scripts) 1.0
This program plots the deformation field (displace vectors) contained in vector.txt.