Can anyone tell me how to read from multiple excel files and write cells with common values to a new excel file. The excel file format is .scope. For example, I have "x" vs "y" data in multiple excel files corresponding to a third parameter "z". I would like to make another set of excel files indexed by the parameter "x", which contains "z" vs "y" data. Is it possible using mathematica? Thanks in advance
I have added the sample files for your reference (File x3 is missing). z1,z2,z3 are the original files with columns corresponding to x (x1,x2,x3) and y. I want to make files called x1, x2 and x3 with z values as the first column and y values selected from each of the previous excel files(z1,z2,z3).
If .scope file format is difficult to work with, please suggest a method to convert it to .csv or .xls
Attachments: