Example: dataPilotTableWizard method

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

dataPilotTableWizard method