How to import dates from excel files
1 回表示 (過去 30 日間)
古いコメントを表示
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
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)
回答 (1 件)
Yusuf Suer Erdem
2021 年 12 月 8 日
Could you try like below?
filename = 'Bitcoin_Data_Lab_9.xlsx';
A = readcell(filename);
T = readtable(A)
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!