File Exchange

image thumbnail

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

2 Downloads

Updated 02 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);
%

Comments and Ratings (0)

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!