Matlab cannot read string data

Question

joni nababan 2020-4-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521390-matlab-cannot-read-string-data

评论： joni nababan 2020-4-29

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Star Strider 2020-4-28

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.

请先登录，再进行评论。

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

Answer 1

Adam Danz 2020-4-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/521390-matlab-cannot-read-string-data#answer_428925

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 个评论
显示 5更早的评论隐藏 5更早的评论

joni nababan 2020-4-28

在 MATLAB Online 中打开

hello Adam Danz, please help me again

here is my code

function loadbutton_Callback(hObject, eventdata, handles)
% hObject    handle to loadbutton (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
 [filename,path] = uigetfile('.xlsx')
 
  dataExcel = xlsread(fullfile(path,filename),'sheet1','A2:F50')
  
        global skor;
        global ipk;
        global gjbb;
        global nama;
        cla
        axes(handles.axes1)
        ipk = dataExcel(:,6)
        plot(ipk,'-b.')
        grid on
        legend('Data Mahasiswa')
        ylabel('IPK')
        set(gca,'xtick',0:5:size(ipk))
        set(gca,'XtickLabel',0:5:size(ipk))
        set(gca, 'FontSize', 8)
        axes(handles.axes2)
        skor = dataExcel(:,5)
        plot(skor,'-b.')
        grid on
        legend('Data Mahasiswa')
        ylabel('Skor')
        set(gca,'xtick',0:5:size(skor))
        set(gca,'XtickLabel',0:5:size(skor))
        set(gca, 'FontSize', 8)
        axes(handles.axes3)
        gjbb = dataExcel(:,4)
        plot(gjbb,'-b.')
        grid on
        legend('Data Mahasiswa')
        ylabel('Gaji Beban(Juta)')
        set(gca,'xtick',0:5:size(gjbb))
        set(gca,'XtickLabel',0:5:size(gjbb))
        set(gca, 'FontSize', 8)
        nama = dataExcel(:,2)
        
function processbutton_Callback(hObject, eventdata, handles)
fis=readfis('fuzzy.fis');
        global ipk
        global skor
        global gjbb
        global nama
     
  
      
out = evalfis([ipk, skor, gjbb],fis)
tableData = [nama,ipk, skor,gjbb,out];
tableData = flipud(sortrows(tableData,5));
set(handles.uitable1,'data',tableData(1:10,:),'ColumnName',{'Nama';'IPK';'Skor_Perilaku';'Gaji_Beban';'Output'});

and here is the result

I dont know why the first column is 'NaN'

what should i do to fix it?

Thankyou

Walter Roberson 2020-4-29

在 MATLAB Online 中打开

dataExcel = readtable(fullfile(path,filename), 'sheetname', 'sheet1', 'range', 'A2:F50', 'readvariablenames', false);

joni nababan 2020-4-29

Hi, Walter

Thankyou somuch

请先登录，再进行评论。

Matlab cannot read string data

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

Matlab cannot read string data

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

WeChat

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

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