Excel Column

Generate characters of column indexes for Microsoft Office Excel.
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 (2024). 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

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes

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


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