Extracting data from excel spreadsheet based on shared dates

6 次查看（过去 30 天）
Wendy Cameron
Wendy Cameron 2021-2-20
评论： Wendy Cameron 2021-2-28
I have two spreadsheets. One has the dates for a given plant phenological event. The other has the appropriate weather data for the year related to those dates.
I want to extract the data from the weather spreadsheet for the correspoding dates and add to the plant data sheet. I have attached sample data with an example colour highlighted of where the extracted data should end up.
I've tried some "ismatch" stuff but can't see a way forward. I'm sure it should be easy but I'm not making much progress.
Kindest regards.
  1 个评论
Wendy Cameron
Wendy Cameron 2021-2-22
Actually this is easily done using the lookup function in excel but I just wondered if Matlab had a similar function.

请先登录，再进行评论。

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

回答（1 个）

Jemima Pulipati
Jemima Pulipati 2021-2-25
Hello,
From my understanding, you can use the following functions to read and write data from the excel files.
The readtable() function creates a table by reading columns from any of the supported file formats.
The writetable() function is used to write data to any of the mentioned supported file formats.
  1 个评论
Wendy Cameron
Wendy Cameron 2021-2-28
Thanks for this response but it hasn't really answered the question. I have used excel instead, but just wondered if Matlab had a similar LOOKUP function as excel.
Kind regards, Wendy

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by