 How does it work - Excel Export |
|
|
|
| |
| 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 |
| 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) |
| |
|
| The result will be a file like this example: Excel Export Example |
