Change the format of an excel spreadsheet using matlab

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?

Answer 1

[ES]

doc xlsread

doc xlswrite

and for Formatting please refer Excel ActiveX

Answer 2

[Andrei Bobrov]

[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