getExcelRange(rowLi​mits,columnLimits)

Version 1.0.0.0 (1.5 KB) by Toby
Returns input row / column limits as Microsoft Excel range.
58 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 (2024). 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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes
1.0.0.0

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