Different date storage type between Mac and Win when reading Excel
Mostrar comentarios más antiguos
I'm currently using function "xlsread" in my Matlab code to import an Excel. The first column of Excel is an array of date.
[data, ~, raw] = xlsread('xxx.xlsx')
When I using the R2018b version on Win, the first column was not imported in the var "data", and in var "raw", it was shown as "cell array".
However, when I using the R2018a version on Mac, the first column was imported in the var "data" and it was shown as an array of 5-digit-numbers.
Do you know the reason? I can't transfer my code between two platforms because of this.
1 comentario
Eric Sofen
el 2 de Oct. de 2020
I'd encourage you to use readtable rather than xlsread. It has a lot of new functionality for reading data from Excel files, including better datetime support.
To answer your question in more detail, it will be helpful to see the Excel file.
Respuestas (0)
Categorías
Más información sobre Spreadsheets en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!