Read excel file correctly

1 次查看（过去 30 天）

Joel 2023-4-4

评论： Stephen23 2023-4-4

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.

Mathieu NOE 2023-4-4

use isnan to locate NaN data in columns and remove correponding rows

Stephen23 2023-4-4

The simple MATLAB approach:

Tesfaye Girma 2023-4-4

correct it manually in the excel itself

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

R2023a

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

Translated by