Excel Column String Creator
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 (2024). Excel Column String Creator (https://www.mathworks.com/matlabcentral/fileexchange/25423-excel-column-string-creator), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |