File Exchange

image thumbnail

Excel Column String Creator

version 1.0.0.0 (1.31 KB) by ANC
Creates Excel Column string for writing data to excel worksheet's specific location.

1 Download

Updated 28 Sep 2009

View License

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..

Cite As

ANC (2021). Excel Column String Creator (https://www.mathworks.com/matlabcentral/fileexchange/25423-excel-column-string-creator), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (1)

Unnikrishnan PC

Excellent

MATLAB Release Compatibility
Created with R2009a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!