When you call Rep2excel, if some parameters are omitted, the Rep2excel will use the default value.
For example, if you set default file format as "Excel compatible", the Rep2excel will use this value by default unless you specify another value by URL or command line.
There are 2 ways to change default conversion parameter.
| Command Line Interface |
Run this command: rep2excel --setupstyle
| Web Interface |
If you deploy Rep2excel as CGI application, please visit this page:
http://<server_name:port>/cgi-bin/rep2excel.exe?job=getwebpage&pagename=setdfltvalue
You can also visit Index page of Rep2excel, and then Rep2excel Manager, and then click Change default parameter values for this server.
To reset default value, please click Default button
| Common Parameters |
| Name | Options | Meaning | Remarks |
| filepath | The path of the file to be converted, the path looks like
|
|
|
| fileformat | auto | Rep2excel try to output report in Native Excel format, if fail, it will output files in Excel-compatible format. | |
| delimited | |||
| excel | Rep2excel try to output report in Native Excel format, if fail, return an error. | Requires Excel 97 - 2007 installed on the server |
|
| mht | Excel-compatible format (new) | Requires Excel XP/2003/2007 installed on the client computer |
| Advanced Parameters |
| Name | Options | Meaning | Remarks |
| job | getexcel | Rep2excel will convert the file specified by filepath into ms-excel format, and return the excel file to you. | default |
| gethtml | Rep2excel will return the specified range
of html pages to you. Please specify the range using the pagefrom and pageto parameter. |
||
| preview | Display the html page before convert it to excel. You can view specified range of report, like 'pagestream'. |
||
| sendemail | Send email and attach the file specified by filepath . The filepath parameter and mailto parameter is require. | For Enterprise Edition Only | |
| pagefrom | [0-2,000,000] | Specify the first page you want to process. | |
| pageto | [0-2,000,000] | Specify the last page you want to process. | |
| maxrow | [0-65,000] | Maximum rows in each work sheet. | |
| disposition | attachment | The disposition "attachment" suggests that the user agent should not display the response, but directly enter a dialog ask open or save as . | |
| inline | The disposition "inline" suggests that the user agent (browser) should try to display the response directly. | ||
| enablecolor | yes | Please
use default value |
|
| no | Text colors will be ignored. | ||
| enablefont | yes | ||
| no | Fonts will be ignored. | ||
| ignnum | on | If this parameter is set, number will be treated as normal string. | |
| formatdetect | off | Disable non-number string format detection. | |
| on | Enable non-number string format detection | ||
| pagebreak | on | Display page code on Column A in excel | |
| off | |||
| mailto | Specify the email addr. of recipients.(new) | For Enterprise Edition Only | |
| codepage | Specifies codepage, like utf8/1256/874. 1256 for Arabic, 874 for Thai | Check out the codepage list |