Index in position 2 exceeds array bounds.
显示 更早的评论
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
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
