Code covered by the BSD License  

Highlights from
xlcolumn

5.0

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

xlcolumn

by Fahad Al Mahmood

 

28 Sep 2004 (Updated 30 Sep 2004)

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

The author wishes to acknowledge the following in the creation of this submission:
xlswrite
This submission has inspired the following:
Example of how to save or read data to an Excel archive.

MATLAB release MATLAB 7 (R14)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (2)
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.

29 Jun 2007 Craig Miller

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

Please login to add a comment or rating.
Tag Activity for this File
Tag Applied By Date/Time
data import Fahad Al Mahmood 22 Oct 2008 07:32:02
data export Fahad Al Mahmood 22 Oct 2008 07:32:02
excel Fahad Al Mahmood 22 Oct 2008 07:32:02
activex Fahad Al Mahmood 22 Oct 2008 07:32:02
spreadsheet Fahad Al Mahmood 22 Oct 2008 07:32:02
xls Fahad Al Mahmood 22 Oct 2008 07:32:02
cell Fahad Al Mahmood 22 Oct 2008 07:32:02
column Fahad Al Mahmood 22 Oct 2008 07:32:02

Contact us at files@mathworks.com