Write to Existing Multiple Excel file via Range and Sheet
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Bob Thompson
il 22 Ago 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.
Risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!