The TargetPivotTable object implements the functionality to output data from SQL*XL to a pivot table in MS Excel. The properties of
TargetPivotTable determine the way data is output to Excel. To obtain a reference to the targetPivotTable object use the
Targets property of the SQLXL object. Example: SQLXL.Targets( litPivotTable ).PivotTableLocation
Physically, output is generated by the Statement objects
notably the StmtDQL object that
implements select statements. The execute method of the Statement outputs the
data according to the setting of the Target property on the Statement. If
output will be generated in a pivot table in Excel.
The address of the cell where the pivot table should be created
in the spreadsheet.
Set the cell A5 the starting point where pivot table should be created in the spreadsheet:
SQLXL.SQL.setText Text := "select * from emp" Set SQLSL.SQL.Statements(1).Target = Targets(litPivotTable) Targets(litPivotTable).PivotTableLocation = "A5"
Note: Please record all code through the macro recorder.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.