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 件のコメント

saphir alexandre
saphir alexandre 2024 年 2 月 22 日
any tips would very appreciated
Walter Roberson
Walter Roberson 2024 年 2 月 22 日
Please check
which -all xlsread

サインインしてコメントする。

回答 (1 件)

Austin M. Weber
Austin M. Weber 2024 年 2 月 22 日
編集済み: Austin M. Weber 2024 年 2 月 22 日

0 投票

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 件のコメント

saphir alexandre
saphir alexandre 2024 年 2 月 22 日
thank you for the suggestion but i still got and error
Voss
Voss 2024 年 2 月 22 日
@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';
Voss
Voss 2024 年 2 月 22 日
@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.
saphir alexandre
saphir alexandre 2024 年 2 月 22 日
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

サインインしてコメントする。

質問済み:

2024 年 2 月 22 日

コメント済み:

2024 年 2 月 22 日

Community Treasure Hunt

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

Start Hunting!

Translated by