Importing data from Excel to Matlab problem

2 次查看（过去 30 天）
Simon
Simon 2013-7-2
回答： Bheki SIFUBA 2019-10-19
Hi guys, I'm having a problem important datas from Excel. I used to import ranges because I found it easier, but now I need to gather a whole sheet from Excel. When I use xlsread, The import is working but the first row of my sheet, which contains the name of my variables disappears. I would like to keep em after important. Thank you in advance.

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

回答（3 个）

Evan
Evan 2013-7-2
编辑：Evan 2013-7-2
This has to do with the output arguments when you call xlsread. With only one output argument, only numerical data is read in into separate arrays. With two arguments, numerical and text is read in. If you want to pull the data in all as a single cell array with different datatypes, specify a third output argument, like so:
[num,txt,raw] = xlsread(___);
And if you don't want the separate numerical and text arrays:
[~,~,raw] = xlsread(___);
Simon
Simon 2013-7-2
OK it seems to work, but the result is not really what I expected. When I do :
%
Exemple = xlsread('filename','Database','CD5:CD530');
X1 = dataset(Exemple);
The first cell of the name is now my Variable name. I wanted to have a way to do the same exact thing but with an entire sheet, getting every column and that the first row of every columns become the column's title.
  1 个评论
Evan
Evan 2013-7-3
编辑：Evan 2013-7-3
If the example code you posted is the one you're using, it doesn't look like you're getting raw output. You need to specify your call to xlsread like this:
[~, ~, Example] = xlsread('filename','Database','CD5:CD530');
That should read your excel data into a cell matrix that is essentially a cell-for-cell copy of your excel spreadsheet, no matter the format or datatypes of your different columns.
Apologies if I'm misunderstanding your problem.

请先登录，再进行评论。

Bheki SIFUBA
Bheki SIFUBA 2019-10-19
I have 3 different data types in one cell (column), one is text and the other two are numbers, how can I import in 3 different rows?

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by