Convert index to Excel A1 notation

Convert index to Excel A1 notation used in xlswrite

You are now following this Submission

This function translates an index to the Excel A1 notation that is used in xlswrite.

%%%
function a1String = idx2A1(idx)

alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';

if idx < 27
a1String = alphabet(idx);
else
idx2 = rem(idx,26);
if idx2 == 0
a1String = [alphabet(floor(idx/26)-1),'Z'];
else
a1String = [alphabet(floor(idx/26)),alphabet(idx2)];
end
end
%%%

Cite As

Matt Brunner (2026). Convert index to Excel A1 notation (https://www.mathworks.com/matlabcentral/fileexchange/28794-convert-index-to-excel-a1-notation), MATLAB Central File Exchange. Retrieved .

Acknowledgements

Inspired: Column index to Excel A1 notation Converter

General Information

MATLAB Release Compatibility

  • Compatible with any release

Platform Compatibility

  • Windows
  • macOS
  • Linux
Version Published Release Notes Action
1.0.0.0