MATLAB Answers

how can I read different data types from excel file

10 views (last 30 days)
yasser
yasser on 3 Dec 2019
Answered: galaxy on 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 Comments

Sign in to comment.

Accepted Answer

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

  0 Comments

Sign in to comment.

More Answers (1)

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

  0 Comments

Sign in to comment.

Products


Release

R2011b

Community Treasure Hunt

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

Start Hunting!

Translated by