필터 지우기
필터 지우기

How to import dates from excel files

조회 수: 1 (최근 30일)
Matthew Urena
Matthew Urena 2021년 12월 8일
편집: Matthew Urena 2021년 12월 9일
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
Mitchell Thurston
Mitchell Thurston 2021년 12월 8일
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 2021년 12월 8일
Definitely looked hopeful, but this is what the first rows of my table were output as:

댓글을 달려면 로그인하십시오.

답변 (1개)

Yusuf Suer Erdem
Yusuf Suer Erdem 2021년 12월 8일
Could you try like below?
filename = 'Bitcoin_Data_Lab_9.xlsx';
A = readcell(filename);
T = readtable(A)
  댓글 수: 1
Matthew Urena
Matthew Urena 2021년 12월 8일
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)

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

태그

제품


릴리스

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by