ExcelColumnAdd

determine the alphabetic characters of column index at a relative position in Excel sheet

% determine the alphabetic characters of column index at a relative position in Excel sheet
%
% [e-mail]
% 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);
%