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

3 次查看（过去 30 天）
DY
DY 2023-9-20
编辑： Florian Bidaud 2023-9-20
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?

请先登录，再回答此问题。

回答（1 个）

Florian Bidaud
Florian Bidaud 2023-9-20
编辑：Florian Bidaud 2023-9-20
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')

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by