[VBScript]
Property Count As Long (read-only)

[VBScript]
Property Item(Table As Variant) As IPivotTable (read-only)

Item represents a single PivotTable in a IPivotTables collection. In VBScript, Item is the default property of the IPivotTables object, so IPivotTables(1) is equivalent to IPivotTables.Item(1). You can reference an Item either by number or by name.

In C#, Item is the indexer for the IPivotTables class.

[VBScript]
Function CreatePivotTable(aDataRange As SARange, 
			aRow As Long, 
			aColumn As Long) 
			As IPivotTable

CreatePivotTable takes a range of cells containing source data and creates a new PivotTable. The method takes three parameters:

[VBScript]
Set XlwApp = Server.CreateObject("SoftArtisans.ExcelWriter")

'--- Open the workbook containing source data for the PivotTable.
XlwApp.Open "c:\reports\pivotdata.xls"

'--- Get a reference to the source data sheet.
Set wsData = XlwApp.Worksheets("DataSheet")	

'--- Create a second worksheet and name it PivotSheet.
Set wsPivot = XlwApp.Worksheets(2)
wsPivot.Name = "PivotSheet"

'--- The data in the workbook is in a named range called 
'--- DataNamedRange.  Get an SARange object representing 
'--- that range.
Set rngData = XlwApp.NamedRange("DataNamedRange")

'--- Pass CreatePivotTable the range of source data to 
'--- create the PivotTable.
Set pvtTable = wsPivot.PivotTables.CreatePivotTable(rngData, 2, 2)
...