How to overwrite labels and data in an excel file?

21 views (last 30 days)
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?

Answers (1)

Ameer Hamza
Ameer Hamza on 16 Oct 2020
Edited: Ameer Hamza on 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.
Sadiq Akbar
Sadiq Akbar on 18 Oct 2020

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by