Clear Filters
Clear Filters

Read excel file correctly

3 views (last 30 days)
Joel on 4 Apr 2023
Commented: Stephen23 on 4 Apr 2023
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
%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.
Mathieu NOE
Mathieu NOE on 4 Apr 2023
use isnan to locate NaN data in columns and remove correponding rows

Sign in to comment.

Accepted Answer

Tesfaye Girma
Tesfaye Girma on 4 Apr 2023
correct it manually in the excel itself

More Answers (0)




Community Treasure Hunt

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

Start Hunting!