My code keeps telling me with an error "Index Exceeds Array Bounds" HELP PLEASE

3 次查看（过去 30 天）
Mohammad Junayed
Mohammad Junayed 2018-10-25
编辑： OCDER 2018-10-25
please help me to solve the error;
(i attached the file)

请先登录，再回答此问题。

采纳的回答

OCDER
OCDER 2018-10-25
编辑：OCDER 2018-10-25
At line 54:
  • You cannot read a .xlsx file properly via fopen. Use xlsread instead.
  • You should define "Path" variable as directory path, and "File" variable as the file. Currently, ASDPath is the user.xlsx, which is a file.
  • Use the full path to a file, and not just the relative path to current working directory. fullfile(ASDPath, ASDFile), where " ASDPath" should be the "path" todirectory, and " ASDFile" should be the "file" ending with .xlsx
  • Add an error check after the fopen to help with debug
ASDPath = 'C:\User\Desktop\....\'; %PATH to your file
ASDFile = 'user.xlsx';
[NumData, StrData, AllData] = xlsread(fullfile(ASDPath, ASDFile));
[f, ErrMsg] = fopen(ASDPath, 'r'); %This won't work for xlsx file. okay for txt file.
assert(f > 0, ErrMsg); %If FID < 0, fopen failed. So this will tell you what the error is.

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by