How to overwrite labels and data in an excel file?

18 vues (au cours des 30 derniers jours)
Sadiq Akbar
Sadiq Akbar le 16 Oct 2020
Commenté : Sadiq Akbar le 18 Oct 2020
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?

Réponses (1)

Ameer Hamza
Ameer Hamza le 16 Oct 2020
Modifié(e) : Ameer Hamza le 16 Oct 2020
All of the following functions for writing to excel sheet support 'range' option for writing to excel file
You can specify the range like B1:B100 to replace the first 100 cells of column B in the excel sheet.
  14 commentaires
Sadiq Akbar
Sadiq Akbar le 17 Oct 2020
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 le 18 Oct 2020
https://www.mathworks.com/matlabcentral/answers/617363-how-to-get-a-cdf-plot-of-my-data

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by