image thumbnail

Excel Named Ranges

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


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 (2022). Excel Named Ranges (, MATLAB Central File Exchange. Retrieved .

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

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!