Borrar filtros
Borrar filtros

How to import dates from excel files

1 visualización (últimos 30 días)
Matthew Urena
Matthew Urena el 8 de Dic. de 2021
Editada: Matthew Urena el 9 de Dic. de 2021
Upon running the following code:
filename = 'Bitcoin_Data_Lab_9.xlsx';
A = xlsread(filename);
T = readtable(filename)
The outputs are similar to the spreashseet but not identical. A has completely deleted the dates column and only shows the numerical ones, while T has every column but every date which was in the dates column is now NaN (my dates are formatted as (mm/dd/yyyy). How can I make it so that the dates are displayed (preferably with xlsread but either function is acceptable).
For reference, the excel file is attached above.
  2 comentarios
Mitchell Thurston
Mitchell Thurston el 8 de Dic. de 2021
my guess is you're going to want to interpret the dates column as a string. going off of this, it would be something like
opts = detectImportOptions(filename);
opts = setvartype(opts, 'Dates','string');
T = readtable(filename, opts)
Matthew Urena
Matthew Urena el 8 de Dic. de 2021
Definitely looked hopeful, but this is what the first rows of my table were output as:

Iniciar sesión para comentar.

Respuestas (1)

Yusuf Suer Erdem
Yusuf Suer Erdem el 8 de Dic. de 2021
Could you try like below?
filename = 'Bitcoin_Data_Lab_9.xlsx';
A = readcell(filename);
T = readtable(A)
  1 comentario
Matthew Urena
Matthew Urena el 8 de Dic. de 2021
After running this, I am met with the following error messages:
Error using readtable (line 198)
File input must be a non-empty character vector or string scalar.
Error in Untitled (line 4)
T = readtable(A)

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by