Read excel file correctly
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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
el 4 de Abr. de 2023
use isnan to locate NaN data in columns and remove correponding rows
Stephen23
el 4 de Abr. de 2023
The simple MATLAB approach:
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!