PublishObjects不发布图像 [英] PublishObjects does not publish images

问题描述

我有一张工作表，图片覆盖了所选的单元格。  当我使用PublishObjects.Add方法从工作表中打印printarea时，我不会打印图像。  这是我的代码：

I have a worksheet with images overlaying selected cells.  When  I use the PublishObjects.Add method to print a printarea from a sheet, I do not get the images printed.  Here is my code:

    With ActiveWorkbook.PublishObjects.Add(xlSourcePrintArea, _
        "E:\Golf\Spreadsheets\sched.htm", _
        "Public Schedule", _
        "", _
        xlHtmlStatic, _
        "ID1", _
        "")
        .Publish (True)
        .AutoRepublish = False
    End With

我有什么方法可以发布包含图像的HTML页面？

Is there any way I can publish an HTML page that includes the images?

推荐答案

是否还有其他XlHtmlType？

Is any other XlHtmlType Works?

HtmlType

可选

变体

指定项目是保存为交互式Microsoft Office Web组件还是静态文本和图像。可以是
XlHTMLType 常量之一：
xlHtmlCalc ， xlHtmlChart ， xlHtmlList 或
xlHtmlStatic 。

Specifies whether the item is saved as an interactive Microsoft Office Web component or as static text and images. Can be one of the XlHTMLType constants: xlHtmlCalc, xlHtmlChart, xlHtmlList, or xlHtmlStatic.

这篇关于PublishObjects不发布图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！