Write to Existing Multiple Excel file via Range and Sheet

1 次查看（过去 30 天）

joms 2018-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415645-write-to-existing-multiple-excel-file-via-range-and-sheet

评论： Bob Thompson 2018-8-22

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 个评论
显示 1更早的评论隐藏 1更早的评论

joms 2018-8-22

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 2018-8-22