getExcelRange(rowLi​mits,columnLimits)

버전 1.0.0.0 (1.5 KB) 작성자: Toby
Returns input row / column limits as Microsoft Excel range.
다운로드 수: 58
업데이트 날짜: 2016/8/30

라이선스 보기

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

인용 양식

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

MATLAB 릴리스 호환 정보
개발 환경: R2016a
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux
카테고리
Help CenterMATLAB Answers에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!
버전 게시됨 릴리스 정보
1.0.0.0

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