Code covered by the BSD License  

Highlights from
Excel Named Ranges

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

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