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)
after that you can unite with row number to create exact location like:
rN = 1;
>> L = strcat(cN,num2str(rN))
Of course you could use this while reading an excel data too..
ANC (2021). Excel Column String Creator (https://www.mathworks.com/matlabcentral/fileexchange/25423-excel-column-string-creator), MATLAB Central File Exchange. Retrieved .
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!