Problem with importing data from excel file on Mac

3 次查看（过去 30 天）
Valentina
Valentina 2011-4-18
I want to import data from an excel file to Matlab, but my attempts have failed so far. I am a Mac user.

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

采纳的回答

Walter Roberson
Walter Roberson 2011-4-18
If you are using anything other than a Windows system with Excel installed, then xlsread() can only handle "Basic" files.
http://www.mathworks.com/help/techdoc/ref/xlsread.html
'basic' Flag to request reading in basic mode, which is the default for systems without Excel for Windows. In basic mode, the xlsread function:
Only reads XLS files.
Imports the entire active range of the worksheet.
Requires a string to specify the sheet, and the sheet name is case sensitive.
Does not support function handle inputs.

更多回答（1 个）

D
D 2011-4-18
csvread might work in this case, if you're working from one worksheet, but only want a specific range of the data.
http://www.mathworks.com/help/techdoc/ref/csvread.html
You'd have to convert your data, but I think it works for Mac as well.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by