Excel Named Ranges

Return the list of named ranges from an Excel file.

Description

%XLSRANGENAMES Returns a list of named ranges in an excel workbook
% RangeNames = XLSRangeNames(filename)
% RangeNames is a (n x 2) cell array with the name of the named range in
% the first column and the value (aka location) in the second column
%
% The value is an excel formula similar to: '=Sheet1!$A$1'
%
% RangeStatus returns a 1 if at least one named range to return, 0
% otherwise
%
% Author: Stephen Lienhard
%
% Example:
% filename = 'C:\mytest.xls'
% [ RangeNames , RangeStats ] = XLSRangeNames(filename);

• Acknowledgements: This submission has inspired the following:; Store Excel named range in MATLAB
• MATLAB release: MATLAB 7.0.1 (R14SP1)
• Other requirements: Microsoft Excel