File Exchange

image thumbnail

getExcelRange(rowLi​mits,columnLimits)

version 1.0.0.0 (1.5 KB) by Toby
Returns input row / column limits as Microsoft Excel range.

1 Download

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 (2021). getExcelRange(rowLimits,columnLimits) (https://www.mathworks.com/matlabcentral/fileexchange/58917-getexcelrange-rowlimits-columnlimits), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (0)

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!