Code covered by the BSD License  

Highlights from
xlcolumn

5.0

5.0 | 2 ratings Rate this file 17 Downloads (last 30 days) File Size: 1.56 KB File ID: #5942

xlcolumn

by

 

28 Sep 2004 (Updated )

Converts Excel column name to column number and vise versa.

| Watch this File

File Information
Description

xlcolumn(column)
 
    column: Can be either column name (characters) or column number (positive integers).
 
NOTE: Excel sheet is limited to 256 columns. Therefore, column number should be between (1-256) and column name should be between ('A' - 'IV').
  
  Example:
    xlcolumn('K')
    xlcolumn('EQ')
    xlcolumn(234)
    xlcolumn(19)

Acknowledgements

Xlswrite inspired this file.

This file inspired Example Of How To Save Or Read Data To An Excel Archive..

MATLAB release MATLAB 7 (R14)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (2)
29 Jun 2007 Craig Miller

Works exactly as intended. Solved a problem for me quickly and kept me from having to write a function.

17 Nov 2004 Hector Fibbs

Thanks for providing all these effort towards linking Matlab and Excel.
I think you should consider releasing a toolbox and updating it instead of dispatching new files seperately.

Contact us