Column Converter for Excel (Scripts) Publisher's description
from Kevin Crosby
B = XLSCOL(A) takes input A, and converts to corresponding output B
B = XLSCOL(A) takes input A, and converts to corresponding output B. The input may be a number, a string, an array or matrix, an Excel range, a cell, or a combination of each within a cell, including nested cells and arrays.
The output maintains the shape of the input and attempts to "flatten" the cell to remove nesting.
Numbers and symbols within strings or Excel ranges are ignored.
xlscol(256) % returns 'IV'
xlscol('IV') % returns 256
xlscol('A1:IV65536') % returns [1 256]
See more examples in help comments.
CELLFUN and ARRAYFUN allow the program to recursively handle multiple inputs. An interesting side effect is that mixed input, nested cells, and matrix shapes can be processed.
I adapted the modular math from Mike Sheppard's program ExcelCol, to properly handle the conversion from column number to strings. His program is at http://www.mathworks.com/matlabcentral/fil...lumn-conversion
System Requirements:MATLAB 7.10 (2010a)
Program Release Status: Major Update
Program Install Support: Install and Uninstall