Excel Named Ranges
%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 (2024). Excel Named Ranges (https://www.mathworks.com/matlabcentral/fileexchange/6706-excel-named-ranges), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
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!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |