how to read excel data in matlab?

Question

SONI SONI 2016-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/273648-how-to-read-excel-data-in-matlab

回答： Walter Roberson 2016-4-15

I have daily time series data for 10 year in excel sheet (365 values in every year). Now I want to monthly sum this daily data and create a monthly time series (12 values of every year). How to import this excel sheet in matlab? I imported the excel sheet in matlab using import tool but, matlab is not reading format of date.

Example: Date data

         01-01-2000   45
         02-01-2000   25
         03-01-2000   88..............
         31-01-2000   56
         01-02-2000   69
         02-02-2000   28
         03-02-2000   63..............
         28-02-2000   91

3 个评论
显示 1更早的评论隐藏 1更早的评论

Explorer 2016-3-15

编辑：Explorer 2016-3-15

Upload your excel file and your code file to let others help you in a better way.

Helen Kirby 2016-4-15

This is what I did: Change your DD-MM-YYYY format in your Excel file to MM/DD/YYYY or MM/DD/YY. When it is in this form you can add the constant 695422 to change it from the XL date number to the ML date number. Say your XL date is in J4, you use (J4)+695422. You should keep the XL date around because it is a nuisance to keep having to work out the date from 736085 e.g. After you have a column of ML dates, read in the file as Explorer says above then start picking out your months as you require. You may need "Datevec" for that process.

请先登录，再进行评论。

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