how can I read different data types from excel file

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

Answer 1

[Fangjun Jiang]

[NUM,TXT,RAW]=xlsread(FILE). Get the Raw data.

Answer 2

[galaxy]

You also use readtable function

data = readtable(FILE,'Sheet', 'sheet_name', 'ReadVariableNames', false);