excel worksheet in matlab

4 views (last 30 days)
Waqas Siddique
Waqas Siddique on 25 Oct 2020
Commented: dpb on 25 Oct 2020
How do I read a Microsoft Excel worksheet into MATLAB as a table? I know how to read it as csv by
Table=readtable('filename.csv')
but I want to read as xls

Answers (1)

Ameer Hamza
Ameer Hamza on 25 Oct 2020
readtable(): https://www.mathworks.com/help/matlab/ref/readtable.html also works for xls file.
  1 Comment
dpb
dpb on 25 Oct 2020
And if the Excel file is complex, better results will usually be had by using detectImportOptions first; simple files are generally brought in as desired.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!