Uploading Exact data from Excel

2020 8 11
1 个回答
更新时间：2020 8 11
2 次查看（30 天）

0 个投票

I have an excel file that I already modified the data in it and I did some calculation to convert seconds into hours and minutes. When I upload the file to matlab the calculations vanish and I see different numbers that is not from the original excel file.

2 个评论
显示 无 隐藏 无

KSSV
KSSV 2020-8-11
How did you upload?
Doaa Alamoudi
Doaa Alamoudi 2020-8-11
[~,~,Edited]= xlsread( 'CPhase1.xlsx','Edited','A1:AU10');

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2020-8-11

0 个投票

readtable().
You are probably seeing excel date numbers, which are relative to Jan 1, 1900

2 个评论
显示 无 隐藏 无

Doaa Alamoudi
Doaa Alamoudi 2020-8-11
not working. I tried to import it from import button still it shows different numbers although I changed the column to dateand time.

请先登录，再进行评论。

类别

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

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by