MATLAB Answers

Write to Existing Multiple Excel file via Range and Sheet

1 view (last 30 days)
joms
joms on 21 Aug 2018
Commented: Bob Thompson on 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 Comments

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!

Translated by