MATLAB Answers

Matlab cannot read string data

7 views (last 30 days)
joni nababan
joni nababan on 28 Apr 2020
Commented: joni nababan on 29 Apr 2020
Hi everyone,
please help me,
i have a xls file with 6 column. First column is string type and others are numeric. i don't know why i cant read the first column data with 'xlsread'. maybe because it is string. is there any way to read my first column?
Thankyou

  1 Comment

Star Strider
Star Strider on 28 Apr 2020
The xlsread funciton has three possible outputs. The first is numeric data, the second is character data, and the third is a cell array of everything in the file. Return all the outputs, then experiment with how best to extract the non-numeric data you want.

Sign in to comment.

Answers (1)

Adam Danz
Adam Danz on 28 Apr 2020
Straight out of the documentation
num = xlsread(filename) reads the first worksheet in the Microsoft® Excel® spreadsheet workbook named filename and returns the numeric data in a matrix.
Try using readtable or readcell.

  7 Comments

Show 4 older comments
joni nababan
joni nababan on 29 Apr 2020
i have use readtable but it's error
this is the error
Error using readtable (line 129)
Invalid parameter name: sheet1.
Walter Roberson
Walter Roberson on 29 Apr 2020
dataExcel = readtable(fullfile(path,filename), 'sheetname', 'sheet1', 'range', 'A2:F50', 'readvariablenames', false);
joni nababan
joni nababan on 29 Apr 2020
Hi, Walter
Thankyou somuch

Sign in to comment.


Translated by