how to load and read excel data into matlab?

1.969 visualizzazioni (ultimi 30 giorni)
Natasha
Natasha il 24 Giu 2015
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 Commento
Katalin
Katalin il 24 Giu 2015
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..

Accedi per commentare.

Risposte (4)

Image Analyst
Image Analyst il 24 Giu 2015
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 il 4 Feb 2020
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 Commento
Walter Roberson
Walter Roberson il 4 Feb 2020
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.

Accedi per commentare.


Nhlamulo Neftor Baloyi
Nhlamulo Neftor Baloyi il 23 Ago 2022
Results_Recorded=xlsread('riverresults.xlsx')
  1 Commento
Walter Roberson
Walter Roberson il 23 Ago 2022
No, this would give nan for the second column and for M36 'UNSURE LOOK AT FILEPG'

Accedi per commentare.


Hans Scharler
Hans Scharler il 9 Gen 2023
I would take a look at "readtable" in MATLAB.
filename = 'myfile.xlsx';
T = readtable(filename);
  1 Commento
Walter Roberson
Walter Roberson il 9 Gen 2023
My responses above imply that there is a text entry inside a numeric column. You would need readcell()

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by