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)
Show older comments
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
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
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.
Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!