File Exchange

image thumbnail

Excel Named Ranges

version 1.0 (1.99 KB) by

Return the list of named ranges from an Excel file.



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

Comments and Ratings (0)

MATLAB Release
MATLAB 7.0.1 (R14SP1)

Inspired: Store Excel named range in MATLAB

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video