image thumbnail

xlsrange

version 1.0.0.0 (1.37 KB) by Richard Crozier
Generates an excel range from row and column number

728 Downloads

Updated 22 Apr 2013

View License

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

Cite As

Richard Crozier (2021). xlsrange (https://www.mathworks.com/matlabcentral/fileexchange/41449-xlsrange), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2012a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags
Acknowledgements

Inspired by: Column Converter for Excel

Community Treasure Hunt

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

Start Hunting!