Excel Column

版本 1.0.2 (1.2 KB) 作者: Daniel YC Lin
Generate characters of column indexes for Microsoft Office Excel.
5.0
(1)
103.0 次下载
更新时间 2020/2/13

查看许可证

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.

引用格式

Daniel YC Lin (2025). Excel Column (https://www.mathworks.com/matlabcentral/fileexchange/74255-excel-column), MATLAB Central File Exchange. 检索时间: .

MATLAB 版本兼容性
创建方式 R2019b
兼容任何版本
平台兼容性
Windows macOS Linux
类别
在 Help Center 和 MATLAB Answers 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

版本 已发布 发行说明
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