How to overwrite labels and data in an excel file?

11 次查看（过去 30 天）
Sadiq Akbar
Sadiq Akbar 2020-10-16
评论： 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?

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

回答（1 个）

Ameer Hamza
Ameer Hamza 2020-10-16
编辑：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更早的评论
Sadiq Akbar
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
Sadiq Akbar 2020-10-18
https://www.mathworks.com/matlabcentral/answers/617363-how-to-get-a-cdf-plot-of-my-data

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by