Clear Filters
Clear Filters

Change the format of an excel spreadsheet using matlab

11 views (last 30 days)
I have numerous spreadsheets in the format of tab 2 attached, and I want to convert them to the format of the one in tab 1. Is this possible using matlab, rather than me having to retype in all the numbers again?

Accepted Answer

ES
ES on 28 Nov 2018
Edited: ES on 28 Nov 2018
doc xlsread
doc xlswrite
and for Formatting please refer Excel ActiveX

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 28 Nov 2018
Edited: Andrei Bobrov on 28 Nov 2018
[data,c] = xlsread('for_Alex.xlsx',2);
out = for_alex(data,c,53,[5,33]);
here for_alex - function:
function out = for_alex(data,c,rows,cols)
cls = cols(1):cols(2);
Baume = data(1:rows,cls-1)';
DOY = data(1:rows,1);
GDD = data(1:rows,2);
Block = c(5,cls)';
Variety = c(3,cls)';
lo = ~isnan(Baume);
[ii,jj] = find(lo);
Vintage = repmat(year(datenum(c(6),'dd.MM.yyyy')),nnz(lo),1);
out = table(Vintage,DOY(jj),GDD(jj),Block(ii),Baume(lo),Variety(ii),...
'v',{'Vintage','DOY','GDD','Block','Baume','Variety'});
end

Tags

Community Treasure Hunt

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

Start Hunting!