TargetXLS Object |
|
Class clsTargetXLS is a subclass of:
| Target |
The TargetXLS object implements the functionality to output data from SQL*XL to a new binary .xls MS Excel file. The properties of TargetXLS determine the way data is output to the .xls file. To obtain a reference to the TargetXLS object use the Targets property of the SQLXL object. Example: SQLXL.Targets( litXLS ).Headings = False
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 Statement.Target = litXLS then output will be generated in a new .xls file.
| Name | Data Type | Description |
| Filename | As String | File name for the new .xls file. (Full path!) |
| Headings | As Boolean | Print column headings |
Create output to a new binary .xls file:
SQLXL.SQL.setText Text := "select * from emp"
Set SQLSL.SQL.Statements(1).Target= Targets(litXLS )
Targets(litXLS).FileName = "c:\test.xls"
Targets(litXLS).Headings = True
SQLXL.SQL.Statements(1).Execute
Note: Please record all code through the macro recorder.