Index in position 2 exceeds array bounds.

10 次查看(过去 30 天)
clc;clear;close all;warning off;
% Proses membaca data latih dari excel
filename = 'CurahHujan.xlsx';
sheet = 2;
xlRange = 'D8:P19';
Data = xlsread(filename, sheet, xlRange);
data_latih = Data(:,1:12)'; <---
target_latih = Data(:,13)';<---
[m,n] = size(data_latih);
i dont know why that line getting an error. it says "Index in position 2 exceeds array bounds."

采纳的回答

Ameer Hamza
Ameer Hamza 2020-9-29
编辑:Ameer Hamza 2020-9-29
For some reason, the value in your excel file are stored as text instead of numeric values. The best solution is to fix the excel file. The following code shows how you can read your current excel file in MATLAB
% Proses membaca data latih dari excel
filename = 'CurahHujan.xlsx';
sheet = 2;
xlRange = 'D8:P19';
Data = table2cell(readtable(filename, 'Sheet', sheet, 'Range', xlRange));
Data = cellfun(@str2double, Data);
data_latih = Data(:,1:12)';
target_latih = Data(:,13)';
[m,n] = size(data_latih);

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by