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.
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)
Images are not compatible (The ext cannot insert images in the pdf document)
Cell width:
The width of the pdf table cell
Cell text align:
The text alignment of the pdf table cell
Header settings:
This are the settings for the header font and background of the table
The table header is repeated for each page
Cell settings:
This are the font, border and background settings for each cell of the pdf table
The line width must be in decimal format like 0,3, if you don't want the border-line you must setup the width to 0 (zero)
General settings:
This are the settings for the pdf
Page size:
The page format. Available size are: A3 - A4 - A5 - Letter - Legal
Orientation:
Can be Portrait or landscape
Margins:
The margins between the pdf table and the page
Page numbers:
If checked insert the page number with the format: "Page x of xx" and can be left/center/right page aligned.
