How to overwrite labels and data in an excel file?

9 次查看（过去 30 天）

Sadiq Akbar 2020-10-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/616243-how-to-overwrite-labels-and-data-in-an-excel-file

评论： Sadiq Akbar 2020-10-18

If I have an Excel file having labels in columns A1,B1,C1,D1,E1,F1,G1,H1,I1 and J1. Below the labels are numeric data. Now if I want to overwrite the labels in B1,E1,G1. Also if I want to overwrite the numeric data below E1 and G1, how will I do that?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Ameer Hamza 2020-10-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/616243-how-to-overwrite-labels-and-data-in-an-excel-file#answer_515908

编辑：Ameer Hamza 2020-10-16

All of the following functions for writing to excel sheet support 'range' option for writing to excel file

writetable(): https://www.mathworks.com/help/matlab/ref/writetable.html

writematrix(): https://www.mathworks.com/help/matlab/ref/writematrix.html

writecell(): https://www.mathworks.com/help/matlab/ref/writecell.html

You can specify the range like B1:B100 to replace the first 100 cells of column B in the excel sheet.

14 个评论
显示 12更早的评论隐藏 12更早的评论

Sadiq Akbar 2020-10-17

Thank you very much dear Ameer Hamza. Indeed you are a true helper. I am very happy from you. Ok I will try to arrange Matlab 2020b if I could. But currently I am not having it. Its expensive too. Thank you very much once again. May you live long to keep helping the needy like me.

Sadiq Akbar 2020-10-18