Read Excel File into code

Question

Robyn Macartney 2019-11-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/491085-read-excel-file-into-code

评论： Robyn Macartney 2019-11-14

Hi I have created code to determine a true/false response based on multiple user input data which is stored in an excel file. Is there a way I can write some code to get the data within the excel file to be entered into the MatLab inputs?

I have attempted using csvread function and can't get this to work. Any suggestions welcome, thank you!

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

Alex Mcaulley 2019-11-14

Have you tried with xlsread?

请先登录，再进行评论。

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

Answer 1

hector martinez 2019-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/491085-read-excel-file-into-code#answer_401536

在 MATLAB Online 中打开

Csvread will only read an excel file with numeric values. If your values aren't numeric or if you have column names that aren't numeric, it won't work. You can get around this by skipping the first row of your data so it won't read your column headers.

csvResponse = csvread('csvFile',1,0)

and changing your true/false values to 1/0.

I prefer using readtable, because your data can be any type. Additionally, column headers can be used as variables, and you can use dot notation to access values in the table.

tableResponse = readtable('csvFile');
% Replace Column1 with the name of whatever column your trying to access, x is the index of the value you want.
someResponse = tableResponse.Column1(x)

My favorite feature is being able to gather data from one column based on values from a different column, such as:

anotherResponse = tableResponse.Column1(tableResponse.Column2 == someCondition)

This says get the values from Column1 where the values in Column2 equal someCondition.

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

Robyn Macartney 2019-11-14

Thanks, I managed to get my file to be read into the code as a matrix using readmatrix function. This matrix is 13 columns of variables for a number of subjects, is there a way I would be able to write code to enable each row to be read and the variables entered into my condition statements? And repeat for each subject case?

请先登录，再进行评论。