Excel Column String Creator

Creates Excel Column string for writing data to excel worksheet's specific location.

When you use the "xlswrite" (or "xlsread") function sometimes you need to specify the excel worksheet column to write Matlab Data. For example (from Matlab Help on xlswrite)

s = xlswrite('tempdata.xls', d, 'Temperatures', 'E1')
"E1" means in excel is
column number = 5 ;
row number = 1 ;

If you use xlswrite command automatically you need a converter that converts the "5"th column to "E".

For example let the xlswrite command as;

s = xlswrite('tempdata.xls', d, 'Temperatures', L)

suppose "L" is a variable you should create in your code..

>> cN= xlsColStr(5)

cN =

E

after that you can unite with row number to create exact location like:

rN = 1;

>> L = strcat(cN,num2str(rN))

L =

E1

Of course you could use this while reading an excel data too..