Uploading Exact data from Excel

1 visualización (últimos 30 días)
Doaa Alamoudi
Doaa Alamoudi el 11 de Ag. de 2020
Comentada: Doaa Alamoudi el 11 de Ag. de 2020
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 comentarios
KSSV
KSSV el 11 de Ag. de 2020
How did you upload?
Doaa Alamoudi
Doaa Alamoudi el 11 de Ag. de 2020
[~,~,Edited]= xlsread( 'CPhase1.xlsx','Edited','A1:AU10');

Iniciar sesión para comentar.

Respuestas (1)

Walter Roberson
Walter Roberson el 11 de Ag. de 2020
readtable().
You are probably seeing excel date numbers, which are relative to Jan 1, 1900
  2 comentarios
Doaa Alamoudi
Doaa Alamoudi el 11 de Ag. de 2020
not working. I tried to import it from import button still it shows different numbers although I changed the column to dateand time.
Doaa Alamoudi
Doaa Alamoudi el 11 de Ag. de 2020

Iniciar sesión para comentar.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by