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

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?

Answer 1

[Florian Bidaud]

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')