ExcelColumnAdd
% determine the alphabetic characters of column index at a relative position in Excel sheet
%
% GuoChao@ntu.edu.cn
% 2-Sep-2020
% %
% Input :
% 1. colCharX1: original alphabetic characters
% 2. n: the number to be added
% 'A': 1; 'B': 2; ...; 'Z':26; 'AA': 27; ...
%
% % Examples :
% ExcelColumnAdd('A', 26) % ans = 'AA'
%
% e.g. when you determine the range in a Excel sheet for a datatable dt
% if the upper left cell is 'B2', then you get range4dt:
% [nrow, ncol] = size(dt)
% range4dt=sprintf('%s%d:%s%d', 'B', 2, charAdd('B', ncol - 1), 2 + nrow - 1);
% eSheetx = eSheet1.get('Range', range4dt);
%
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxTags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0 |