How to save plots to the specified sheet in an existing Excel file?
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
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')
0 Comments
See Also
Categories
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!