Publisher review:Excel Named Ranges - Return the list of named ranges from an Excel file. XLSRANGENAMES Returns a list of named ranges in an excel workbookRangeNames = 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 columnThe value is an excel formula similar to: '=Sheet1!$A$1'RangeStatus returns a 1 if at least one named range to return, 0 otherwiseExample:filename = 'C:mytest.xls'[ RangeNames , RangeStats ] = XLSRangeNames(filename);
Excel Named Ranges is a Matlab script for Scientific/Engineering scripts design by Stephen Lienhard.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris