Create on:
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
Request variable
when the generic request variable exists
Session variable
when the session variable exists
Application variable
when the Application 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)
