试用软件

How to load files(xls, xlsx, etc.) in the current directory to the workspace

11 次查看（过去 30 天）

显示更早的评论

千惠洪 2020-8-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/575053-how-to-load-files-xls-xlsx-etc-in-the-current-directory-to-the-workspace

回答： Arthur Roué 2020-8-4

采纳的回答： Arthur Roué

在 MATLAB Online 中打开

I have a file named dataset.xlsx and now I want to load it on my workspace instead of click the "import data" button. I tried to use the load method but it cannot work, and the error showed that "Error using load.Unable to read file 'dataset.xlsx'. Input must be a MAT-file or an ASCII file containing numeric data with same number of columns in each row"

load('dataset.xlsx');

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

请先登录，再进行评论。

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

采纳的回答

Arthur Roué 2020-8-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/575053-how-to-load-files-xls-xlsx-etc-in-the-current-directory-to-the-workspace#answer_475096

load() function is for MAT file or ASCII file;

For Excel workbook, you can use readcell, readtable or readmatrix according to your data and output format.

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

请先登录，再进行评论。

更多回答（0 个）

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

类别

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!

Translated by

试用软件