image thumbnail

Excel Named Ranges

version 1.0.0.0 (1.99 KB) by Stephen Lienhard
Return the list of named ranges from an Excel file.

1.3K Downloads

Updated 12 Jan 2005

View License

%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);

Cite As

Stephen Lienhard (2021). Excel Named Ranges (https://www.mathworks.com/matlabcentral/fileexchange/6706-excel-named-ranges), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R14SP1
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired: Store Excel named range in MATLAB

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!