Invoke 'SaveAs' in excel to save sheet as '.htm' format.

8 次查看（过去 30 天）
Himanshu Verma
Himanshu Verma 2021-11-8
回答： Cris LaPierre 2021-11-11
I'm using ActxServer to write some content to an excel sheet and add images to it in different tabs. If I manually use 'SaveAs' option in excel, the sheet can be saved as '.htm' file. But I want to invoke the same function and save my excel sheet as a '.html' file using ActxServer. How to do that?

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2021-11-11
I found this answer from 2009 that gives insight into how to do this. The optional variant argument "43" is used to specify an older version of MATLAB.
Knowing that, you can use this table to find the correct value for the format you desire. For xlHtml, it is 44.
The final code should look something like this
workbook.SaveAs('filename.htm',44);

类别

在 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