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.

2 次查看（过去 30 天）
Muhammad Salman Sarfraz
编辑： Michal Dobai 2017-12-19
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!

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

采纳的回答

Michal Dobai
Michal Dobai 2017-12-19
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.
xslread documentation

更多回答（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