how can I read different data types from excel file

15 views (last 30 days)
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

Accepted Answer

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

More Answers (1)

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

Products


Release

R2011b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!