how can I read different data types from excel file

12 次查看（过去 30 天）
yasser
yasser 2019-12-3
回答： galaxy 2019-12-4
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

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

采纳的回答

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

更多回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2011b

Community Treasure Hunt

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

Start Hunting!

Translated by