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)
100 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 (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
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