When transforming data that will be shown in the resulting excel report, these are the values that can be selected for the Type
attribute of the Cell
element:
Unknown = -1,
Numeric = 0,
String = 1,
Formula = 2,
Blank = 3,
Boolean = 4,
Error = 5,
Date = 100
<Cell Id="{AS:GenerateId()}" Index="1" RowIndex="{position()+$rowShift}" Type="1">
<Value><xsl:value-of select="@Name"/></Value>
</Cell>
<Cell Id="{AS:GenerateId()}" Index="2" RowIndex="{position()+$rowShift}" Type="0">
<Value><xsl:value-of select="@Quantity"/></Value>
</Cell>