Define various options for the download - Magic, Lookup, Excel.
Mydb.dbDownloadParams = "(;,~)Magic | StripHtmlTags| LookUp | Excel | ForceDownload| titlebgcolor| titlecolor| headerbgcolor| headercolor|row1bgcolor| row1color| row2bgcolor| titlerow| row2color| sumbgcolor| sumcolor| CSUM=col1,col2| InsertAfterCol = column, caption, formula ~..... Repeat"
| Keyword | Description |
|---|---|
| Field | Download field to be processed by MAgicCell filter. |
| Tag | Tag of field |
| Macro | MagicCell Macro. (See MagicCell reference) |
| Magic | Use Magic Filter - True / False (def) |
| StripHtmlTags | Strip all Html tags from grid/title/Agg templates - True / False (def) |
| LookUp | Use LookUp Filter - True / False (def) |
| Excel | Download as Excel - True / False(Def) |
| ForceDownload | Def=False. If set to True then a content-disposition attachment will be issued. This is the same as the Command line param of the ASPdbDownload except it applies to Excel download. |
| InsertAfterCol | Insert a column after this one with - Column_number, Caption, formula. (0 based) |
| CSUM | Fields to sum at the bottom (index separated by commas) |
| TitleRow | Def=1. how many rows Title occupies. e.g. <H3> occupies 2 rows. |
| titlebgcolor | Def=yellow. Title bg color. (Excel download color) |
| titlecolor | Def=black. Title text color. (Excel download color) |
| headerbgcolor | Def=black. Header bg color. (Excel download color) |
| headercolor> | Def=white. Header text color. (Excel download color) |
| row1bgcolor | Def=black. Zebra row 1 bg color. (Excel download color) |
| row1color | Def=black. Zebra row 1 cell text color. (Excel download color) |
| row2bgcolor | Def=lightgrey. Zebra row 2 cell text color. (Excel download color) |
| row2color | Def=black. Zebra row 2 bg color. (Excel download color) |
| sumbgcolor | Def=cyan. Sum cell bg color. (Excel download color) |
| sumcolor | Def=black. Sum cell text color. (Excel download color) |
| DownloadTitle | Excel directly download title. |
If Magic is specified, a new query will be fired to get the raw data and then downloadMagicCell will be applied. Otherwise, the Display data will be used.
See Special Topic - Download for more details.
z Class | Tornado Namespace | dbDownloadFlds | dbDownloadHideFlds | dbDownloadMagicCell | ASPdbDownload | Special Topics - Download