getExcelRange(rowLi​mits,columnLimits)

Versione 1.0.0.0 (1,5 KB) da Toby
Returns input row / column limits as Microsoft Excel range.
0.0
(0)
58 download
Aggiornato 30 ago 2016

Visualizza la licenza

% 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'
%

Cita come

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

Compatibilità della release di MATLAB
Creato con R2016a
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Versione Pubblicato Note della release
1.0.0.0

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