Share via


WorkbookBase.PublishObjects Property

Gets the Microsoft.Office.Interop.Excel.PublishObjects collection.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public ReadOnly Property PublishObjects As PublishObjects
    Get
public PublishObjects PublishObjects { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.PublishObjects
The Microsoft.Office.Interop.Excel.PublishObjects collection.

Examples

The following code example uses the PublishObjects property to publish all static Microsoft.Office.Interop.Excel.PublishObject items in the active workbook to the Web page.

This example is for a document-level customization.

Private Sub WorkbookPublishObjects()
    Dim i As Integer
    For i = 1 To Me.PublishObjects.Count
        If Me.PublishObjects(i).HtmlType = _
            Excel.XlHtmlType.xlHtmlStatic Then
            Me.PublishObjects(i).Publish()
        End If
    Next i
End Sub
private void WorkbookPublishObjects()
{
    for (int i = 1; i <= this.PublishObjects.Count; i++)
    {
        if (this.PublishObjects[i].HtmlType ==
            Excel.XlHtmlType.xlHtmlStatic)
        {
            this.PublishObjects[i].Publish(missing);
        }
    }
}

.NET Framework Security

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace