Install Rep2excel

Rep2excel provides 2 user interfaces

1. Command line interface
2. Common Gateway Interface (CGI)

According to usage of Rep2excel, there are 2 types of installation.

It is simple, do the following steps.

1. Download Rep2excel installation pack (zip file)
2. Unzip the installation pack to any folder you want
3. Run rep2excel.exe --help in dos window, see the command line usage.

1. Please make sure your web-server supports CGI, the Apache is recommended.

2. Download Rep2excel installation pack (zip file)

3. Unzip the installation pack to any folder you want.
There are a few files and folders that are extracted from installation pack (zip file).
You will see Rep2excel.exe and r2xls folder.

4. Copy files to web server directory.
1) Copy rep2excel.exe to the CGI directory.
   For Apache 2, the default CGI directory may be C:\Program Files\Apache Group\Apache2\cgi-bin\
   For OHS, the default CGI directory is ORACLE_HOME\apache\apache\cgi-bin\
   For MS-IIS, the default CGI dirctory may be C:\Inetpub\Scripts\

If you are using IIS6.0 or higher version, you may need to create the CGI directory manually. see Create and Configure CGI folder for IIS 6.0 below.

   If other server, please refer to help of the server.
2) Copy the r2xls folder to the root of the web server.
If your server is Apache 2, the default CGI directory may be C:\Program Files\Apache Group\Apache2\htdocs\

Tip: The r2xls folder contains CSS, JS, and Help documents.

5. Test the Rep2excel.

Use IE to test whether rep2excel works. Sample URL, you should changed the port and server address.
   If your server is OHS, the URL may be http://server_name:7777/cgi-bin/rep2excel.exe
   If your server is Apache 2, th URL may be http://server_name:80/cgi-bin/rep2excel.exe
   If your server is MS-IIS, the URL may be http://server_name:80/scripts/rep2excel.exe
A web page will appear if you open the URL above.

Add this page to favorites, it is not nessary, but recommended.

At the bottom of this page, you will see the links. If the links not exists, please make sure the r2xls folder is copied to the root of the web server

6. If you are using MS-IIS, you need to view this topic Configure Excel application to support Rep2excel.

Some high version of IIS (For example IIS6.0/7.0)will not create CGI folder when it is installed, so you should create it manually.

It is easy, just follow the wizard.

1. Open Internet Information Services (IIS) Manager. (Click Start -> All programs -> Administrative Tools -> Internet Information Services (IIS) Manager )
2. Right click the web site ( named Default Web Site under Web Sites by default) -> choose New -> choose Virtual Directory...
3. The Virtual Directory Creatation Wizard dialog display, type Alias, for example scripts.
4. Enter path to the directory, for example C:\Inetpub\scripts, you should create the folder manually.
5. In the Access Permissions page, check the Execute (such as ISAPI applications or CGI).
6. Click Finish.
7. In IIS Manager, click the Web Service Extensions folder.
8. In the details pane, select the All unknow CGI extensions, and then click Allow

To allow anonymous access, you should select the folder you want to change, open properities dialog, choose Directory Security tab, click Edit.. , check Enable anonymous access.

Just remove all the files downloaded and the Rep2excel.exe and r2xls folder in the web server folder.