View License

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

» Watch video

Highlights from
Excel Named Ranges

Join the 15-year community celebration.

Play games and win prizes!

» Learn more

Be the first to rate this file! 0 Downloads (last 30 days) File Size: 1.99 KB File ID: #6706 Version: 1.0

Excel Named Ranges

by

 

10 Jan 2005 (Updated )

Return the list of named ranges from an Excel file.

| Watch this File

File Information
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 file inspired Store Excel Named Range In Matlab.

MATLAB release MATLAB 7.0.1 (R14SP1)
Other requirements Microsoft Excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us