How to save plots to the specified sheet in an existing Excel file?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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?
0 Kommentare
Antworten (1)
Florian Bidaud
am 20 Sep. 2023
Bearbeitet: Florian Bidaud
am 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')
0 Kommentare
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!