Contains information about all published items in a workbook.
| Element |
Description |
| PublishObject |
Contains the properties of a published item. |
| Id |
Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range. |
| DivID |
Contains the unique identifier used to identify an HTML DIV element on a Web page. The element is associated with an item in a document that is published to a Web page. The item can be an entire workbook, a worksheet, a selected print range, an AutoFilter range, a range of cells, a chart, a PivotTable report, or a query table. |
| SourceType |
Specifies the type of item being published. |
| Source |
Contains the name of a published item or range, or specifies the character set of a text data source. |
| HtmlType |
Specifies the type of HTML generated and the component used by Microsoft Excel when an item is published to a Web page. |
| Location |
Contains an A1-style reference to a range in the worksheet containing a PivotTable report, or contains the URL (on the intranet or the Web) or path (local or network) to the location where a published item is saved. |
| AutoRepublish |
Specifies where in the HTML document to place the published objects. |
| DivID |
Contains the unique identifier used to identify an HTML DIV element on a Web page. The element is associated with an item in a document that is published to a Web page. The item can be an entire workbook, a worksheet, a selected print range, an AutoFilter range, a range of cells, a chart, a PivotTable report, or a query table. |