How to save plots to the specified sheet in an existing Excel file?

1 view (last 30 days)
I use matlab to have some data processing to an Excel file that only contains rawdata in sheet1. The processed data will be generated and added to sheet2 and sheet3 of the oringinal Excel file.
Now I'd like to plot figures based on the data in sheet2 and save the figures in sheet2, also the same operation to sheet3. How can I realize that?

Answers (1)

Florian Bidaud
Florian Bidaud on 20 Sep 2023
Edited: Florian Bidaud on 20 Sep 2023
In the functions associated with Excel reading or writing, you usually have a 'Sheet' parameter, for example, to write on the second sheet:
writecell({'a' 1},'excel_file.xls','Sheet',2)
Or with the sheet name :
writecell({'a' 1},'excel_file.xls','Sheet','sheet name')


Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!