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.

2 Comments

any tips would very appreciated
Please check
which -all xlsread

Sign in to comment.

Answers (1)

Austin M. Weber
Austin M. Weber on 22 Feb 2024
Edited: Austin M. Weber on 22 Feb 2024
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 Comments

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

Sign in to comment.

Asked:

on 22 Feb 2024

Commented:

on 22 Feb 2024

Community Treasure Hunt

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

Start Hunting!