Extracting select data from excel sheets

2 次查看（过去 30 天）
Vince Clementi
Vince Clementi 2019-6-5
评论： dpb 2019-6-5
Hello.
I am currently trying to merge data from two excel sheets (A and B) into a third excel sheet (C):
A = xlsread('file1','sheet','column1');
B = xlsread ('file1','sheet','column2');
C= xlsread('file2','sheet','column');
A and C are similar; A has every value of C, but C does not have every value of A (i.e., A is longer and contains values that are not present in C). Moreover, A has corresponding values in B. I need to extract all of the values for A and B that correspond with C while leaving all other values as NaN. Is this possible?
  1 个评论
dpb
dpb 2019-6-5
Makes no sense -- you start off with no C but then the description of the development of the content of C is dependent upon existing C content.
Try again to describe what A and B contain and what merge operation you're after.
Probably a short(ish) example would ease the comparison.
Look at the various join operations and/or ismember and related friends...

请先登录，再进行评论。

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

回答（0 个）

类别

在 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