Change the format of an excel spreadsheet using matlab

11 次查看（过去 30 天）
Wendy Cameron
Wendy Cameron 2018-11-28
编辑： Andrei Bobrov 2018-11-28
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?

请先登录，再回答此问题。

采纳的回答

ES
ES 2018-11-28
编辑：ES 2018-11-28
doc xlsread
doc xlswrite
and for Formatting please refer Excel ActiveX

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2018-11-28
编辑：Andrei Bobrov 2018-11-28
[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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by