[Back to Part I ]
Setup default conversion parameter
There are 2 ways to change default conversion parameter.
1) Run this command: rep2excel --setupstyle
2) If you deploy Rep2excel as CGI application, please visit this page:
http://<server_name:port>/cgi-bin/rep2excel.exe?job=getwebpage&pagename=setdfltvalue
To reset default value, please click Default
button
Advanced Parameters
| Name | Options | Meaning | Remarks |
| filepath | A string that is the path to the desired
file. The path can be relative or absolute. e.g. ..\wwwroot\emp_list_cl.htm ../htdocs/emp_list_cl.htm C:\Oracle\iSuites\Apache\Apache\htdocs\emp_list_cl.htm The
path can be an URL, e.g. |
Please encode the filepath parameter
to a URL safety parameter. click here. If you do not specify the filename |
|
| filename | A string that is the name to the desired file. | Work with the 'basedir' parameter. | |
| basedir | A string that is the path to the desired file. | Work with the 'filename' parameter. if the 'filename' parameter is not specified, this parameter is skiped. basedir and filename equals filepath. |
|
| 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. (new) | 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. | |
| fileformat | auto | Rep2excel try to output report in ms-excel format, if fail, it will output files in delimited format. | |
| delimited | |||
| excel2000 | Rep2excel try to output report in ms-excel format, if fail, return an error. | ||
| 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 | ||
| 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 in excel | |
| off | |||
| mailto | Specify the email addr. of recipients.(new) | For Enterprise Edition Only |