Code covered by the BSD License  

Highlights from
xlsrange

Be the first to rate this file! 18 Downloads (last 30 days) File Size: 1.37 KB File ID: #41449

xlsrange

by

 

Generates an excel range from row and column number

| Watch this File

File Information
Description

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

Acknowledgements

Column Converter For Excel inspired this file.

MATLAB release MATLAB 7.14 (R2012a)
Other requirements http://www.mathworks.co.uk/matlabcentral/fileexchange/28343-column-converter-for-excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.

Contact us