Creates a new, blank pivot table for the specified area.
Signature |
---|
|
public PivotTable CreatePivotTable(Area data, int aRow, int aColumn)
|
Signature |
---|
|
Public Function CreatePivotTable(ByVal data As Area, ByVal aRow As Integer, ByVal aColumn As Integer) As PivotTable
|
Param |
---|
|
The data that is represented within the pivot table. |
Param |
---|
|
The 0-based number of the row of the upper left corner of the pivot table. |
Param |
---|
|
The 0-based number of the column of the upper left corner of the pivot table. |
Example |
---|
Code Block |
---|
|
ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
Worksheet ws = wb.Worksheets[0];
Area data = ws.CreateArea(0, 0, 10, 10);
PivotTable pt = ws.PivotTables.CreatePivotTable(data, 11, 11);
|
Code Block |
---|
|
Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
Dim ws As Worksheet = wb.Worksheets(0)
Dim data As Area = ws.CreateArea(0, 0, 10, 10)
Dim pt As PivotTable = ws.PivotTables.CreatePivotTable(data, 11, 11);
|
|