Write to Existing Multiple Excel file via Range and Sheet

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]

[Bob Thompson]

Is the above matlab code? As far as I'm aware, the print command is used to physically print something, not save to a file.

If you are looking for the command to write some data to an excel file look at xlswrite(). It automatically overwrites whatever is within the specified range when it writes the new data.

[joms]

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]

https://www.mathworks.com/help/matlab/ref/xlswrite.html This is the page for xlswrite(). It has options for choosing file, sheet, and range.