Using the load command to import data into matlab

2016 9 25
1 个回答
回答已采纳
更新时间：2016 9 25
12 次查看（30 天）

0 个投票

Hey everyone,
I'm a new user to MATLAB and I'm already having trouble in importing data into MATLAB. I have an excel file, or spreadsheet, that I want to import into a variable into MATLAB. I've tried using the load and import function but I keep getting errors such as 'unknown text in line 1' or 'uninterpretable data'. Could I please get help in how I can make it work?
Thanks

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

 采纳的回答

Walter Roberson
Walter Roberson 2016-9-25

0 个投票

Use xlsread() or readtable() for spreadsheets.

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Diego Espinosa
Diego Espinosa 2016-9-25
The xlsread() was able to accept it but it couldn't be saved into a variable.
Thanks anyway
Stephen23
Stephen23 2016-9-25
编辑：Stephen23 2016-9-25
"The xlsread() was able to accept it but it couldn't be saved into a variable."
How do you know that? Were you were calling it correctly? If you actually gave us details of what you are doing then we could actually help you. You claim that you are "a new user to MATLAB", but now you apparently know exactly what MATLAB can and cannot do.
Make a new comment: show us the code that you are trying and upload a sample file for us to try out.
Walter Roberson
Walter Roberson 2016-9-25
[num, txt, raw] = xlsread('TheFileName.xls');
num would then be just the numeric portion; txt would be the text headers; raw would be a cell array combining the two in proper position.
Diego Espinosa
Diego Espinosa 2016-9-25
I'm still receiving the same type of error about "unknown text on line 1"
So far I haven't started in any other form of code. I've only been trying to import an excel spreadsheet and save it to a variable
A = xlsread('filename.xls.')
[num, txt, raw] = xlsread('filename.xls');
It has been able to accept it because its shown in the workspace but there isn't any data displayed, it counts it as empty.
Stephen23
Stephen23 2016-9-25
编辑：Stephen23 2016-9-25
@Diego Espinosa: please make a new comment and tell us:
  1. Which MATLAB version you are using.
  2. What operating system you are using.
  3. Whether you have MS Office installed.
  4. The complete error message (all of the red text).
  5. And upload a sample data file for us (click the paperclip button).

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by