MATLAB Answers

Change the format of an excel spreadsheet using matlab

97 views (last 30 days)
Wendy Cameron
Wendy Cameron on 28 Nov 2018
Edited: Andrei Bobrov on 28 Nov 2018
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?

  0 Comments

Sign in to comment.

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

  0 Comments

Sign in to comment.

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

  0 Comments

Sign in to comment.

Sign in to answer this question.

Tags