You are now following this Submission
- You will see updates in your followed content feed
- You may receive emails, depending on your communication preferences
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
General Information
- Version 1.0.0.0 (1.14 KB)
MATLAB Release Compatibility
- Compatible with any release
Platform Compatibility
- Windows
- macOS
- Linux
| Version | Published | Release Notes | Action |
|---|---|---|---|
| 1.0.0.0 |
