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 Commenti

any tips would very appreciated
Please check
which -all xlsread

Accedi per commentare.

Risposte (1)

Austin M. Weber
Austin M. Weber il 22 Feb 2024
Modificato: Austin M. Weber il 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 Commenti

thank you for the suggestion but i still got and error
Voss
Voss il 22 Feb 2024
@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

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by