File Exchange

image thumbnail

xlsrange

version 1.0 (1.37 KB) by

Generates an excel range from row and column number

4 Downloads

Updated

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

Comments and Ratings (0)

MATLAB Release
MATLAB 7.14 (R2012a)
Tags Add Tags
Acknowledgements

Inspired by: Column Converter for Excel

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video