Write to Existing Multiple Excel file via Range and Sheet

4 Ansichten (letzte 30 Tage)
joms
joms am 21 Aug. 2018
Kommentiert: Bob Thompson am 22 Aug. 2018
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
joms
joms am 22 Aug. 2018
I was mistaken its a write command i want. That is not a matlab code i only showed it or illustration purpose. Can you help me convert it in matlab code.
Bob Thompson
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.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by