<ST_WebSourceType> (Web Source Type)

This is an enumeration of types of objects which can be selected from the workbook to be published as HTML. For example, the entire sheet can be published, or a narrower set of objects on the sheet can be published, like a chart or a range.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value


<autoFilter> (AutoFilter)

Auto filter

<chart> (Chart)


<label> (Label)


<pivotTable> (PivotTable)


<printArea> (Print Area)

Print area

<query> (QueryTable)

Query Table

<range> (Range)

Range of cells

<sheet> (All Sheet Content)

All content of a sheet

Referenced By


The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_WebSourceType">
	<restriction base="xsd:string">
	<enumeration value="sheet"/>
	<enumeration value="printArea"/>
	<enumeration value="autoFilter"/>
	<enumeration value="range"/>
	<enumeration value="chart"/>
	<enumeration value="pivotTable"/>
	<enumeration value="query"/>
	<enumeration value="label"/>