Excel Column

Version 1.0.2 (1.24 KB) by Daniel YC Lin
Generate characters of column indexes for Microsoft Office Excel.
5.0
(1)
106 Downloads
Updated 13 Feb 2020

View License

Convert a positive integer into MS Excel column index format, helpful when applying functions like "writematrix". Note that the limits of row and column in MS Excel (2007+) are 1,048,576 and 16,384, respectively.

Cite As

Daniel YC Lin (2026). Excel Column (https://www.mathworks.com/matlabcentral/fileexchange/74255-excel-column), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2019b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Version Published Release Notes
1.0.2

add identification to inputs:
(1) double - positive integers, and (2) character - all letters
1.0.1

It also returns the number of column index if inputs were characters.

1.0.0