Read excel file correctly
1 次查看(过去 30 天)
显示 更早的评论
I have an excel file that shows 24 values for every day of the year. However, there exists empty rows that needs to be removed.
Although, the Excel-file might look different from year to year, most certainly when there is a leap year.
%Read and edit data
Data=readtable("Data.xlsx");
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1344674/image.png)
%Remove empty/unnecessary rows
Data([32:36,65:69,101:105,136:140,172:176,207:211,243:247,279:283,314:318,350:354,385:390,422],:) = [];
% The script continues with
for j=1:365
...
However there will be 366 days during a leap year so j must be defined differently.
采纳的回答
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!