Loading data from Excel file

Question

Tino 2019-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459560-loading-data-from-excel-file

评论： Guillaume 2019-5-1

采纳的回答： Walter Roberson

Hello

Please can anyone assist me on how to load data from excel file using the function load

Thanks in advance

Tino

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

Guillaume 2019-5-1

You cannot use the function load to read excel file, and it's puzzling why you think you could. load only works for loading mat files (and a few types of text files that are better read with other functions).

See KSSV's answer for which functions to use.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2019-5-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459560-loading-data-from-excel-file#answer_373091

The only kind of "excel file" that you can use with load() is a .csv file. In order to use a .csv file with load(), it must be purely numeric with no headers, and with no text, and with no missing entries.

.xls and .xlsx files can never be used with load(). .csv files with missing entries or with any text anywhere cannot be used with load(). Also, .csv files that use comma as the decimal separator will not be interpreted correctly by load() if they manage to load at all.