excel worksheet in matlab

2 次查看（过去 30 天）

显示更早的评论

Waqas Siddique 2020-10-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/625608-excel-worksheet-in-matlab

评论： dpb 2020-10-25

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Ameer Hamza 2020-10-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/625608-excel-worksheet-in-matlab#answer_524023

readtable(): https://www.mathworks.com/help/matlab/ref/readtable.html also works for xls file.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2020-10-25

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.

请先登录，再进行评论。

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by