Converting dates from Excel Spreadsheet into MATLAB

9 次查看（过去 30 天）
Sarah
Sarah 2011-10-5
Hey everyone,
I have a quick question. I am trying to convert date strings from an excel spreadsheet into MATLAB. For example, lets say I have the following:
A1 1/1/2000 12:00 %mm\dd\yyyy hh:mm
A2 1/2/2000 12:05
A3 1/3/2000 12:08
B1 5
B2 6
B3 8
How can I plot the numerical data in column B as the y axis and the date strings as the x axis? I know I use xlsread. I have something like:
[excelDates, Test] = xlsread('date.xlsx');
I know its a relatively simple question, but any help would be greatly appreciated (:
~Sarah~

请先登录，再回答此问题。

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-10-5
What value do you get in excelDates after running that xlsread() command? You can plot the data directly and then use datetick('x').
[Value, Time] = xlsread('test.xls')
Time=datenum(Time);
plot(Time,Value);
datetick('x',0,'keepticks');
  10 个评论
显示 8更早的评论
Fangjun Jiang
Fangjun Jiang 2011-10-7
Delete all the cells below the third row, even though they look empty. Some cells may contain whitespace.
Sarah
Sarah 2011-10-7
You were right! :O I deleted the empty cells, and I guess some of it had white space because they work after deleting! Thanks so much!!
I asked everything on a "conceptual level" so I could understand the basics. Now I will apply it to my real problem. Thanks again (:
Now

请先登录，再进行评论。

更多回答（0 个）

类别

在 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!

Translated by