Borrar filtros
Borrar filtros

Read excel file correctly

2 visualizaciones (últimos 30 días)
Joel
Joel el 4 de Abr. de 2023
Comentada: Stephen23 el 4 de Abr. de 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
Data=readtable("Data.xlsx");
%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.
  2 comentarios
Mathieu NOE
Mathieu NOE el 4 de Abr. de 2023
use isnan to locate NaN data in columns and remove correponding rows
Stephen23
Stephen23 el 4 de Abr. de 2023

Iniciar sesión para comentar.

Respuesta aceptada

Tesfaye Girma
Tesfaye Girma el 4 de Abr. de 2023
correct it manually in the excel itself

Más respuestas (0)

Productos


Versión

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by