getExcelRange(rowLi​mits,columnLimits)

Version 1.0.0.0 (1.5 KB) by Toby
Returns input row / column limits as Microsoft Excel range.
59 Downloads
Updated 30 Aug 2016

View License

% Converts input row / column limits to Excel range format
%
% syntax:
% xlRange = getExcelRange(rowLimits,columnLimits)
%
% Inputs rowLimits, columnLimits expected as vectors defining the
% selection limits:
% i.e. rowLimits = [minRow,maxRow]
%
% example(s):
% xlRange = getExcelRange([5,10],[5,10]);
% returns xlRange as 'E5:J10'
%

Cite As

Toby (2026). getExcelRange(rowLimits,columnLimits) (https://www.mathworks.com/matlabcentral/fileexchange/58917-getexcelrange-rowlimits-columnlimits), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2016a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Version Published Release Notes
1.0.0.0

Added error handling logic for negative row/column range inputs.