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

1 次查看(过去 30 天)
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.

采纳的回答

Jordan Ross
Jordan Ross 2017-1-13
Hello,
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:

更多回答(0 个)

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by