This example creates a DataPilot table named "TestDataPilotTableWizard" for range ( E20 : I25 ).
Sheet sheet = sheets.item(1); Range src = sheet.range("E20:I25"); Range dest = sheet.range("E3"); DataPilotTable table = sheet.dataPilotTableWizard("TestDataPilotTableWizard", src, dest);
Related information