MATLAB Answers

how can I read different data types from excel file

조회 수: 5(최근 30일)
yasser
yasser 3 Dec 2019
Answered: galaxy 4 Dec 2019
Hello,
I have an excel file with mixed data (charachters and numericals), how can I read this file with these data into one workspace?
I try to use this command [Mat_A_STRS,str]=xlsread(filename4,sheet); the result got into two arraies but I cant merge it into one workspace.
Thank You

  댓글 수: 0

로그인 to comment.

채택된 답변

Fangjun Jiang
Fangjun Jiang 3 Dec 2019
[NUM,TXT,RAW]=xlsread(FILE). Get the Raw data.

  댓글 수: 0

로그인 to comment.

More Answers (1)

galaxy
galaxy 4 Dec 2019
You also use readtable function
data = readtable(FILE,'Sheet', 'sheet_name', 'ReadVariableNames', false);

  댓글 수: 0

로그인 to comment.

이 질문에 답변하려면 로그인을(를) 수행하십시오.

제품


릴리스

R2011b

Translated by