Excel Column

Generate characters of column indexes for Microsoft Office Excel.

Version 1.0.2 (1.24 KB)
107 Downloads
(1)
13 Feb 2020

You are now following this Submission

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 .

Categories

Find more on Spreadsheets in Help Center and MATLAB Answers

General Information

MATLAB Release Compatibility

  • Compatible with any release

Platform Compatibility

  • Windows
  • macOS
  • Linux
Open in new tab
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