Cannot read .xslx file

Question

Nicholas Howe 2024-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2102606-cannot-read-xslx-file

评论： Star Strider 2024-4-17

Agora_I_4985.xlsx

I am trying to read in the attached .xslx file. It is a very simple file: thirteen rows, four columns, all string data. Neither readcell nor readtable works properly. With readcell I get only the first column of data. With readtable I get an error:

>> f = readtable('Agora_I_4985.xlsx')
Error using readtable
Index exceeds the number of array elements. Index must not exceed 1. 
517     throw(ME)
K>> 

Given the simplicity of the file, I am very surprised that this doesn't just work out of the box. What am I missing?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2024-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2102606-cannot-read-xslx-file#answer_1436071

在 MATLAB Online 中打开

Agora_I_4985.xlsx

The R2024a version of readtable has no problems with it. Does this seem to be correct?

T1 = readtable('Agora_I_4985.xlsx', 'VariableNamingRule','preserve')
T1 = 12x4 table
      Agora_I_4985_Rotation1_300dpi_line01.png        Agora_I_4985_Rotation2_300dpi_line01.png         STOKAI          STOKAI_1   
    ____________________________________________    ____________________________________________    _____________    _____________

    {'Agora_I_4985_Rotation1_300dpi_line02.png'}    {'Agora_I_4985_Rotation2_300dpi_line02.png'}    {'ODIKOSES' }    {'*DIKOSE*' }
    {'Agora_I_4985_Rotation1_300dpi_line03.png'}    {'Agora_I_4985_Rotation2_300dpi_line03.png'}    {'IHIDIKHT' }    {'IHIDIKHT' }
    {'Agora_I_4985_Rotation1_300dpi_line04.png'}    {'Agora_I_4985_Rotation2_300dpi_line04.png'}    {'OSENNEAR' }    {'OSENNEA*' }
    {'Agora_I_4985_Rotation1_300dpi_line05.png'}    {'Agora_I_4985_Rotation2_300dpi_line05.png'}    {'AYTOIDI'  }    {'AYTOID*'  }
    {'Agora_I_4985_Rotation1_300dpi_line06.png'}    {'Agora_I_4985_Rotation2_300dpi_line06.png'}    {'NEANTISA' }    {'NEANTISA' }
    {'Agora_I_4985_Rotation1_300dpi_line07.png'}    {'Agora_I_4985_Rotation2_300dpi_line07.png'}    {'SIASEANTO'}    {'SIASEANT*'}
    {'Agora_I_4985_Rotation1_300dpi_line08.png'}    {'Agora_I_4985_Rotation2_300dpi_line08.png'}    {'ODONAIEAN'}    {'ODONAIEA*'}
    {'Agora_I_4985_Rotation1_300dpi_line09.png'}    {'Agora_I_4985_Rotation2_300dpi_line09.png'}    {'NPOLEWSAP'}    {'NPOLEWSAP'}
    {'Agora_I_4985_Rotation1_300dpi_line10.png'}    {'Agora_I_4985_Rotation2_300dpi_line10.png'}    {'NIOSAQHN' }    {'NIOSAQHN' }
    {'Agora_I_4985_Rotation1_300dpi_line11.png'}    {'Agora_I_4985_Rotation2_300dpi_line11.png'}    {'KAIPROSO' }    {'*AIPROS*' }
    {'Agora_I_4985_Rotation1_300dpi_line12.png'}    {'Agora_I_4985_Rotation2_300dpi_line12.png'}    {'ILIONM'   }    {'ILIONM'   }
    {'Agora_I_4985_Rotation1_300dpi_line13.png'}    {'Agora_I_4985_Rotation2_300dpi_line13.png'}    {'EAFE'     }    {'*AF*'     }

It is possible that you have a variable named ‘readtable’. To check, run this from a script or your Command Window —

which readtable -all
/MATLAB/toolbox/matlab/iofun/readtable.m
/MATLAB/toolbox/shared/io/general/+matlab/+io/@ImportOptions/ImportOptions.m  % matlab.io.text.DelimitedTextImportOptions method

The result should be exactly as it is here. If ther are other entries, that is likely the problem. The solution is to re-name the variable to something that does not overshadow any MATLAB function, and makes sense in the context of the code using it.

.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Nicholas Howe 2024-4-17

I can confirm that this happens with my fresh install of R2024a. I will contact support as you suggest.

Star Strider 2024-4-17

Another option is to use MATLAB Online until you can get the problem with your home installation repaired. It has all the Toolboxes you have licensed, however only those. You can copy-paste the results if necessary, and copy-paste any code you write to your home installation.

To import the file to MATLAB Online, you can either use the ‘Import Data’ tab to import the file, or:

filename = websave('Agora_I_4985','https://www.mathworks.com/matlabcentral/answers/uploaded_files/1659291/Agora_I_4985.xlsx')

T1 = readtable(filename, 'VariableNamingRule','preserve')

in your script to read it and work with it.

(I just now tested those commands in MATLAB Online to confirm that they work. They do, and the file imoprts correctly.)

.

请先登录，再进行评论。

Cannot read .xslx file

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

5 个评论
显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

Cannot read .xslx file

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

5 个评论 显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论