how to load and read excel data into matlab?

1,731 次查看（过去 30 天）
Natasha
Natasha 2015-6-24
评论： Walter Roberson 2023-1-9
How could I load and extract each individual column of this attached excel spreadsheet in matlab (excluding the headers only the values)?
Your assistance would be much appreciated
  1 个评论
Katalin
Katalin 2015-6-24
Have you tried the import wizard? It has lots of customisable options which you can make a script of at the end with the settings you want. Sorry if you have done this already..

请先登录，再进行评论。

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

回答（4 个）

Image Analyst
Image Analyst 2015-6-24
Try
[numbers, strings, raw] = xlsread(filename);
Then use indexing to pull out what you want.
column1 = numbers(1:41);
or whatever indexes you want. Beware that not all of those output arguments have the first row as the first row. For example numbers might have the first row as the third row in the workbook if the workbook doesn't have any numbers until row 3.
david muchangi
david muchangi 2020-2-4
Give a name in an Open datatype Matrix-Form, then read the data into it
[riverresults]=xlsread('riverresults.xlsx');
% Syntax is [ Name of variable in matlab to hold data]=xlsread('File name+extension')
I've just tested it.
  1 个评论
Walter Roberson
Walter Roberson 2020-2-4
No, this would replace the second column with NaN when the poster had requested to read everything.
readtable() gets much further, but when used without care, readtable() would replace M36 'UNSURE LOOK AT FILEPG' with NaN.

请先登录，再进行评论。

Nhlamulo Neftor Baloyi
Results_Recorded=xlsread('riverresults.xlsx')
Hans Scharler
Hans Scharler 2023-1-9
I would take a look at "readtable" in MATLAB.
filename = 'myfile.xlsx';
T = readtable(filename);
https://www.mathworks.com/help/matlab/tables.html
  1 个评论
Walter Roberson
Walter Roberson 2023-1-9
My responses above imply that there is a text entry inside a numeric column. You would need readcell()

请先登录，再进行评论。

类别

在 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