xlsrange

Versione 1.0.0.0 (1,37 KB) da Richard Crozier
Generates an excel range from row and column number
1.0
(1)
745 download
Aggiornato 22 apr 2013

Visualizza la licenza

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

Cita come

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

Compatibilità della release di MATLAB
Creato con R2012a
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux
Tag Aggiungi tag
Riconoscimenti

Ispirato da: Column Converter for Excel

Community Treasure Hunt

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

Start Hunting!

Versione Pubblicato Note della release
1.0.0.0