how can I read different data types from excel file

2019 12 3
2 个回答
回答已采纳
更新时间：2019 12 4
7 次查看（30 天）

0 个投票

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

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

 采纳的回答

更多回答（1 个）

galaxy
galaxy 2019-12-4

0 个投票

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

类别

在 帮助中心 和 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