I want to take difference of column A (first column in sheet_1) and column B (also first column in sheet_2). Output should be file C in workspace.
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Muhammad Salman Sarfraz
el 8 de Dic. de 2017
Editada: Michal Dobai
el 19 de Dic. de 2017
Hi, Following question can easily be solved in Excel, But i want to run Matlab code because i have hundreds of file and can't do excel merging or copy pasting columns in new sheets for whole life. Therefore, I want this in matlab. I want to take difference of column A (first column in sheet_1) and column B (also first column in sheet_2). Output should be file C in workspace. A B C 36 33 3 34 31 3 25 34 -9 19 31 -12
Thanks you!
2 comentarios
Image Analyst
el 18 de Dic. de 2017
Michal, do you want to put this down in the Answers section so he can accept it and give you credit (reputation points)?
Respuesta aceptada
Michal Dobai
el 19 de Dic. de 2017
So you have excel file containing two sheets. And you want to:
- subtract numbers in column A in sheet_2 from numbers in column A in sheet_1
- save (just) these differences to excel file named 'C.xlsx'
Is that right? Then you can do this:
A = xlsread('myFile.xlsx', 'sheet_1');
B = xlsread('myFile.xlsx', 'sheet_2');
xlswrite('C.xlsx', A(:,1)-B(:,1) );
In this case input file is 'myFile.xlsx' and names of first and second sheet are sheet_1 and sheet_2. If you don't know exact names, but you know that it's always first and second sheet, you can replace names with their numbers.
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!