MATLAB Answers

Add Column in Excel Workbook, Loop through WorkSheets to fill in Data

3 views (last 30 days)
EL on 9 Jan 2017
Answered: Jordan Ross on 13 Jan 2017
Hello, I have a multi part question I was hoping some one could help me with. I have an existing Excel workbook that has a master spreadsheet and many subsequent data spreadsheets.
I need to append a new column(s) into the master spreadsheet. Then I need to loop through each of the data spread sheets and pull information to fill in the new column (i.e., A2 of each spread sheet). In some cases I would like to manipulate the information I pull before I write it into the new column (i.e., A2-B2). Each row of the master spreadsheet corresponds with the name of the data spreadsheet - the first cell of each row in the master spreadsheet is the name of a data spreadsheet.


Sign in to comment.

Accepted Answer

Jordan Ross
Jordan Ross on 13 Jan 2017
As I understand you are wanting to read and write some data from/to an Excel workbook. The following functions are going to help you in doing this:
  • xlswrite
  • xlsread
The following documentation pages show some examples of how these functions can be used to achieve a similar workflow to what you want:


Sign in to comment.

More Answers (0)


No tags entered yet.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by