Calculate Excel Range

Calculates full target range in Excel A1 notation.

Description

XLCALCRANGE(REFCELL,R,C,M,N) returns the full target range XLRANGE in Excel A1 notation to cover an array of size M rows & N columns and starting from an offset of R rows & C columns from REFCELL.

Any workbook\worksheet prefix is removed from REFCELL, as are any absolute '$' markers prior to range calculation.
i.e.
REFCELL = 'C:\directorypath\[filename.xlsm]worksheet1'!$P$6:$AC$91

becomes:

REFCELL = P6:AC91

REFCELL can also be an Excel named range, but requires Matlab to already have the Excel workbook open in an actxserver process.

Note: this file makes use of 2 functions: dec2base27.m & base27dec.m that were sourced from inside of Mathwork's function, xlswrite.m

Please let me know of any bugs

• MATLAB release: MATLAB 7.11 (2010b)

[Qun HAN]