Clear Filters
Clear Filters

Read matrix of data from excel file, insert row-by-row in another excel file, and save the resultant Excel files with different custom names. How?

1 view (last 30 days)
Hi,
I want to insert a matrix of data, row-by-row from an excel file into another excel file at several places (in different sheets) AND then i want to save the resultant excel file by a name specified in each row of first file.
  2 Comments
Bob Thompson
Bob Thompson on 15 Jan 2019
Everything you're asking for is possible, but the specific commands are fairly situational. Do you have any code written so far? If not, can you be more specific about your answers, or do you just want a general response with some commands listed so you can put a script together on your own?
Guillaume
Guillaume on 15 Jan 2019
While it's certainly possible to do this in matlab, I don't really see the point. You might as well write an excel macro. It'll be faster since all the matlab code would do is copy data back an forth between excel and matlab.

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!