Import excel file into MATLAB on Macbook

12 次查看（过去 30 天）
Yi Hong Jong
Yi Hong Jong 2021-8-25
回答： Sivani Pentapati 2021-9-1
Hello all, I have a problem with a code and I can't seem to find a solution to it.
So I need to read a spreadsheet on MATLAB for my code to work. I tried xlsread but it keeps showing up the error of:
>>Unable to open file '/Users/yvonnejong/Desktop/AB30/03_09_2019/ramp/fp/AB30 Ramp FP with gcRight.xlsx'.<<
How do I go about solving this? I am using a MACBOOK so I think that might be the problem as I've tried the same code on my school Windows computer and it works just fine.
  1 个评论
John D'Errico
John D'Errico 2021-8-25
What is q? I ask, because if it is -1, this is an option that works only on Windoze systems. Otherwise, if q is a positive integer, or the name of a worksheet, then it should open that sheet. Thus, I see in the help:
The following syntaxes are supported only on Windows systems with Excel software:
[NUM,TXT,RAW]=xlsread(FILE,-1) opens an Excel window to select data
interactively.
So what is q?

请先登录，再进行评论。

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

回答（1 个）

Sivani Pentapati
Sivani Pentapati 2021-9-1
From my understanding you want to load data from a spreadsheet to MATLAB. Alternatively, you could use readtable, readmatrix and readcell functions to read data from a spreadsheet as they work with xlsx format as well.

类别

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

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by