Create on:
You can define which event on the page start the create the Excel file.
The value can be:
| On Page Load | on the OnLoad event of the page |
Post variable
| when the request.form variable exists |
Get variable
| when the request.querystring variable exists |
Session variable
| when the session variable exists |
Cookie variable
| when the request.Cookie variable exists |
With this variuos event you can define when the Excel file is created, but the most simple method is create a link in your pages that point to a page where you insert only this extension and that create the Excel on the OnLoad event so when your user click on the link a new browser window is open and the Excel is created and displayed in the browser window.
File name:
The file name of the exported file.
This extension open the "SaveAs" popup browser to download or open the Excel file
All records:
If checked the extension create the Excel with all the records in the recordset, otherwise you can specify a number of record, this can be used to test the page and create a small Excel file only for test or to limit the number of element in the Excel file.
Field label:
If checked the first line of the Excel file will contains the field label list.
Recordset:
In the options Recordset pop-up menu, select the recordset you want to use as a content source.
Recordset fields:
After you select a recordset this element display the list of recordset field with a predefined label, format and tag type.
It's possible personalize all this parameters like you need, you must select a record field in this element and in the 3 element belowe you can modify the label, the format and the tag type for each record field.
With the 4 button in the right you can remove (Del button) the field you don't want export or add (Add button) a field you have deleted and setup the order position for each field with the button Up and Down button.
Tag label:
The label for the Field, when you ckeck the option Field label the first line of the Excel file will contain the list of this label.
Format:
The format of the exported data.
The available format are:
String
Number (Default)
Number (0 decimal)
Number (1 decimal)
Number (2 decimal)
Number (3 decimal)
Number (4 decimal)
Date DD.MM.YYYY
Date DD.MM.YYYY h:m
Date DD.MM.YYYY h:m:s
Date MM.DD.YYYY
Date MM.DD.YYYY h:m
Date MM.DD.YYYY h:m:s
Date YYYY.MM.DD
Date YYYY.MM.DD h:m
Date YYYY.MM.DD h:m:s
Date DD/MM/YYYY
Date DD/MM/YYYY h:m
Date DD/MM/YYYY h:m:s
Date MM/DD/YYYY
Date MM/DD/YYYY h:m
Date MM/DD/YYYY h:m:s
Date YYYY/MM/DD
Date YYYY/MM/DD h:m
Date YYYY/MM/DD h:m:s
Date DD-MM-YYYY
Date DD-MM-YYYY h:m
Date DD-MM-YYYY h:m:s
Date MM-DD-YYYY
Date MM-DD-YYYY h:m
Date MM-DD-YYYY h:m:s
Date YYYY-MM-DD
Date YYYY-MM-DD h:m
Date YYYY-MM-DD h:m:s
Boolean (true/false)
Boolean (1/0)
Boolean (-1/0)
Boolean (yes/no)
Boolean (Y/N)
