Change the format of an excel spreadsheet using matlab

18 visualizzazioni (ultimi 30 giorni)
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?

Risposta accettata

ES
ES il 28 Nov 2018
Modificato: ES il 28 Nov 2018
doc xlsread
doc xlswrite
and for Formatting please refer Excel ActiveX

Più risposte (1)

Andrei Bobrov
Andrei Bobrov il 28 Nov 2018
Modificato: Andrei Bobrov il 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

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by