Write to Existing Multiple Excel file via Range and Sheet
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
How can i overwrite Multiple Excel file specifying the Range and Sheet. There is a pre-added data on the A.xls and B.xls C.xls and I want to override it with the following matrix. Thanks
For example:
xlswrite
File A.xls
Sheet 1- Range B2:F6
matA1=[1 2 3 4 5;1 2 3 4 5 ;1 2 3 4 5]
Sheet 2 -Range A2:E6
matA2=[2 2 2 3 2;2 2 4 2 2 ;2 2 1 2 2]
File B.xls
Sheet 1- Range B2:F6
matA1=[1 2 3 4 5;1 2 3 4 5 ;1 2 3 4 5]
Sheet 2 -Range A2:E6
matA2=[2 2 2 3 2;2 2 4 2 2 ;2 2 1 2 2]
File C.xls
Sheet 1- Range B2:F6
matA1=[1 2 3 4 5;1 2 3 4 5 ;1 2 3 4 5]
Sheet 2 -Range A2:E6
matA2=[2 2 2 3 2;2 2 4 2 2 ;2 2 1 2 2]
3 Kommentare
Bob Thompson
am 22 Aug. 2018
https://www.mathworks.com/help/matlab/ref/xlswrite.html This is the page for xlswrite(). It has options for choosing file, sheet, and range.
Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!