### Setup default conversion parameter

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 ..\wwwroot\emp_list_cl.htm ../htdocs/emp_list_cl.htm C:\Oracle\iSuites\Apache\Apache\htdocs\emp_list_cl.htm /emp_list_cl.htm http://server_name:7777/emp_list_cl.htm |
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