matlab online read excel sheet

Hello,
I'm having some issues with an excel sheet that i am trying to have matlab read. I uplaoded the excel sheet just fine in the files list but when i use the function readtable or xlsread it does not recognize the file. I tried putting the file path instead of the name but that didn't work either.

回答(1 个)

Have you tried specifying the file type as a spreadsheet when using the readtable function?
filename = 'Trial01_8deg (1).xlsx';
DATA = readtable(filename,'FileType','spreadsheet');

4 个评论

thank you for the suggestion but i still got and error
@saphir alexandre: You left out the space in the file name. You wrote:
filename = 'Trial01_8deg(1).xlsx';
The correct file name appears to be:
filename = 'Trial01_8deg (1).xlsx';
@saphir alexandre: I suspect the problem with xlsread was that you have another m-file called xlsread.m somewhere, which is being called instead of the built-in one, because xlsread with one input shouldn't give you the "Not enough input arguments" error.
You should follow Walter's advice and tell us what
which -all xlsread
outputs, in order to confirm that there is another xlsread.m file.
Thank you the tips! I re-uplaoded the file to remove the (1). I don't have an eeror anymore, here is what it looks like now

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by