num2abc

Function that translates numbers to spreadsheet column labels.

Description

NUM2ABC(X), where X is an integer, returns a string corresponding to the column label commonly employed by spreadsheet programs, such as Microsoft
Excel.

 Example:
       x = 45;
       num2abc(x);

       ans =
           AS

• MATLAB release: MATLAB 7.0.4 (R14SP2)

[Jinfeng Li]

When number>702 it gives an error:
K>> ABCtranslate = num2abc(703)
??? Attempted to access alphabetStrings(27); index out of bounds because
numel(alphabetStrings)=26.

Error in ==> num2abc at 54
        ABCtranslate = ...
 
K>> ABCtranslate = num2abc(702)
ABCtranslate =
ZZ
K>>
You see,it doesn't reach the limitation