How to overwrite labels and data in an excel file?

18 visualizzazioni (ultimi 30 giorni)
Sadiq Akbar
Sadiq Akbar il 16 Ott 2020
Commentato: Sadiq Akbar il 18 Ott 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?

Risposte (1)

Ameer Hamza
Ameer Hamza il 16 Ott 2020
Modificato: Ameer Hamza il 16 Ott 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 Commenti
Sadiq Akbar
Sadiq Akbar il 17 Ott 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 il 18 Ott 2020
https://www.mathworks.com/matlabcentral/answers/617363-how-to-get-a-cdf-plot-of-my-data

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by