readtable xlsx with date

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

0 个投票

Hi every one,
i have data in many excell scheets. I wrote a code to read the sheets:
numVars = 6;
VarSheet=1 ;
varNames = {'Date','Time','M1','T1','L1','L2'} ;
varTypes = {'char','char','char','double','double','double'} ;
dataRange = 'A8:F47';
opts = spreadsheetImportOptions('NumVariables',numVars,'VariableNames',varNames,'VariableTypes',varTypes,'DataRange', dataRange...
'Sheet',VarSheet);
% preview('VergleichsmessungSep3.xlsx',opts)
Meas1 = readtable('Test.xlsx',opts);
How could read Date and Time coulmns and use it for plots?

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

 采纳的回答

Jan
Jan 2019-4-29
编辑：Jan 2019-4-29

1 个投票

What about:
varTypes = {'datetime','datetime','char','double','double','double'} ;
What exactly does "use it for plots" mean?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Jan
Jan 2019-4-29
[MOVED from section for answers] Rica wrote:
the goal is to build a datetime Array from Column 1 and column 2. This Array will be used in ploting data in a graphics.
I think your hint to use datetime instead of Char will help me solve this task.
Thank you Jan.
Jan
Jan 2019-4-29
@Rica: I'm glad if I could help you.
Please post comments in the section for comments.
Rica
Rica 2019-4-30
Thanks,
I solve it like this:
DT=Date+timeofday(Time).

请先登录，再进行评论。

更多回答（1 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by