How to read data from excel to a cell?
조회 수: 1(최근 30일)
I have an excel file which is containing [precipitation year month day] respectively. I want to read these data to a cell file with N struct which N is the number of the years in the excel file and each struct has x*y matrix which x is the number of months of a year and y is the number of days in each month.
I am not a professional in matlab and need some hints for starting this code. Thanks for everyone who can help me.
attached you can find an example of my excel file and cell file.
Sulaymon Eshkabilov 2021년 11월 10일
You can get the data from *.xlsx with a few different data import fcns of matlab. Here are two most recommended data import fcns, e.g.:
% D1 is a matrix:
D1 = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/796554/Data.xlsx');
% D2 is a table:
D2 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/796554/Data.xlsx');
XY1 = D1(:,3).*D1(:,4); % Calculated results from readmatrix() data
XY2 = D2.Month.*D2.Day; % Calculated results from readtable() data
You may also consider data import using xlsread(), uiimport(), etc, which are bit slower.