ExcelColumnAdd

Version 1.0.0 (1.58 KB) by chao guo
determine the alphabetic characters of column index at a relative position in Excel sheet
7 Downloads
Updated 2 Sep 2020

View License

% 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
Created with R2020a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.0.0