xlsrange

版本 1.0.0.0 (1.4 KB) 作者: Richard Crozier
Generates an excel range from row and column number
1.0
(1)
745.0 次下载
更新时间 2013/4/22

查看许可证

Simple utility function to generate a range in excel syntax from row and column numbers, requires xlscols.m by Kevin Crosby:

http://www.mathworks.co.uk/matlabcentral/fileexchange/28343-column-converter-for-excel

Syntax

range = xlsrange(row, col)
range = xlsrange(row1, col1, row2, col2)

Description

xlsrange generates cell positions and ranges in excel's letter-number
format, e.g. A1, B5:D9 etc. from row and column numbers.

Examples

range = xlsrange(1, 1)

range =

A1


range = xlsrange(1, 1, 4, 3)

range =

A1:C4

引用格式

Richard Crozier (2024). xlsrange (https://www.mathworks.com/matlabcentral/fileexchange/41449-xlsrange), MATLAB Central File Exchange. 检索时间: .

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

参考作品: Column Converter for Excel

Community Treasure Hunt

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

Start Hunting!

版本 已发布 发行说明
1.0.0.0