Extracting select data from excel sheets
显示 更早的评论
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
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
2019-6-5
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
