Home > Rep2excel
 

Rep2excel * An Oracle Report to Excel Converter

An easy, low cost way to output rich format excel report

The Rep2excel is developed for Oracle Report; it can convert oracle report output to excel format. In other words it can enhance your Oracle Reports Server to generate output with rich formatting from paper layout reports to Excel format


Who need the Rep2excel

Oracle Reports is a comprehensive reporting tool for enterprise wide reporting, information delivery, analysis and decision-making. But you will find it is difficult to generate spreadsheet output from oracle reports. We introduce an easy, low cost way to output rich format excel report.

What is Rep2excel

Rep2excel is a win32 console application, It can convert .html file generated by oracle report server (6i, 9i, 10g) to ms-excel format, you can access the output excel file via browser. We also offer java-based Rep2excel for Linux and other platform, for more information, please view the j-Rep2excel.

Rep2excel can convert report not only in HTML but also in HTMLCSS format to excel format.

Using the Rep2excel, You can

  • Generate report output to spreadsheet format from existing paper layout reports.
  • Preserve the rich layout formatting such as colors, fonts, conditional formatting, graphs, and images.

Example

Why Rep2excel, not other way to get excel report output.

  1. Rich format excel report. What you see in html what you get in excel!
  2. Low cost.Rep2excel enhance your report server to output excel. protect your IT investment.
  3. Easy to use.

Unique Features:

  • Integrate with web-base report, you can call rep2excel from oracle form
  • Support convert report in HTMLCSS format, Preserve the graphic lines
  • Support Multi-worksheet excel format, other than Excel-compatible HTML format
  • Less coding even no coding.

How it works

Rep2excel support CGI interface and command line interface.
You can call it through 2 ways:
  • Deploy Rep2excel as a CGI application, call it from web.
  • Use command line to call rep2excel.(Please use rep2excel --help to get usage)
Rep2excel output excel through 3 ways:
  • Output to file system
  • Output to browser
  • Excel file can be sent by email to be shared between users

    .

    You can install the application inside Apache server as CGI application. You can using 'web.show_document' built-in to invoke the application to convert the oracle report to excel thru web-browser .[See Live Demo]

    Please click here to download an sample code demonstrates how to call rep2excel from oracle forms.


    Quick start (More information at the User's Guide )

    Call Rep2excel through web

    Please see the Live Demo

    1. Install a web server such as Apache ( Oracle http server is based on Apache ).
    2. Copy rep2excel.exe to the directory ORACLE_HOME\apache\apache\cgi-bin\ .Invoke the program by URL http://your_server_name:7777/cgi-bin/rep2excel.exe .the software runs, a web page will appear .
    3. Generate a report file in html or htmlcss format by oracle report server and save to c:\example\ ,the file name is report.htm
    4. Open IE, call the application follow the URL
      http://your_server_name:7777/cgi-bin/rep2excel.exe?baseidr=c:\example\&filename=report.htm .
    5. Now , What you need is inside web-browser!

    Call Rep2excel through command line

    Please see the Live Demo

    Try Rep2excel now?

    Step 1: Download the trial version of Rep2excel. Please click Download Rep2excel

    Step 2: Install Rep2excel. Please see document: Install Rep2excel

    Step 3: Call Rep2excel to convert sample report file. Please see document: Call Rep2excel

    Step 4: Integrate Rep2excel into your application. Please see Call Rep2excel from your application

    linuxsolarisunix

    FAQ: My report server is running on Unix, how can I do to use Rep2excel.

    A: The are two solutions.

    1) Please try the following:

    1. Install rep2excel and MS Office on a windows server.
    2. Invoke rep2excel and specify filepath=URL. (rep2excel can download files from another server).
      e.g. http://dali:7777/cgi-bin/rep2excel.exe?filepath=http://www.lv2000.com/examples/getreport.php

    The figure below demonstrate how the work with Report Server on non-windows server.

    2) Use the j-Rep2excel. The j-Rep2excel is developed by java, so it can be install on a lot of platform. For more information, please see the faster java-based Rep2excel.

    j-Rep2excel The faster Rep2excel

    The Rep2excel is developed by C++. It supports Windows platform only. Perhaps you want to installl Rep2excel on the Linux or Unix, we know your requirements, so we develop the j-Rep2excel by Java language.

    javaThe j-Rep2excel is completely written in Java. It runs on every platform (OS) that supports Java 5 or higher (e.g. Windows, Unix, Solaris, OSX 10.4+, AIX). A GUI is not required for the server.

    Compare Rep2excel and j-Rep2excel

      Rep2excel j-Rep2excel
    Operating System Windows Windows and Linux etc.
    Support web Yes Yes
    Support command line Yesok No
    Number format detection Good Betterok
    Speed Slow for native format
    Fast for compatible format
    Fast for native formatok
    Oracle SSO Yesok Yesok
    Microsoft Office Require Unrestrictedok

    Try j-Rep2excel on Windows

    1. Download self-extractive file of j-Rep2excel, click Here to download.
    2. Run the self-extractive file, extract the installation pack to a folder.
    3. Double click startup.bat, start the server.
    4. Open IE browser, visit http://localhost:8003/.
    5. Convert the sample reports, get rich-formated excel output.

    Live DemoLive demo of step 2-4 is available, please click here and see.

    Note: If you want to uninstall, just remove the folder created at step 2.

    Try j-Rep2excel on Non-Windows

    Please download the free trial version. To learn more on installing and using j-Rep2excel, please see the online HELP document.

    Try j-Rep2excel without download and installation

    You can also try the online server, http://www.lv2000.com:8003/ .

    Download Trial Version

    downloadYou can download and try a free trial version of Rep2excel and test it before purchasing:

    aDownload Rep2excel

    Note: To download Rep2excel for Windows 2000, please contact support@lv2000.com.

    aDownload j-Rep2excel

    Ordering Information

    orderThe free trial usage period of Rep2excel is 60 days. If you would like to use this software after the 60 days evaluation period; a registration is required. You can order the fully licensed version of Rep2excel over the Internet with any major credit card.

    Please click here for more inforamtion.

    Support

  • Feedback, questions and bug reports are welcome and should be sent to the customer support, at support@lv2000.com.
     
    Download Send Personally Download a trial version of Rep2excel:
     Download
    Purchase Send Personally Purchase Rep2excel online through a secure server with any major credit cards.
    Product Home Page
    Screenshots
    User's Guide
    Customer List
    FAQ
    Try Lion Soft's excel report server
         

    Support Convert File On The Web
    Click to enlarge

    Rep2excel Manager

    Click to enlarge


    Client Setup
    Click to enlarge


    Conversion Finished

    Click to enlarge


    The Excel Output:
    Click to enlarge

    Write a Review, Get Free License

    If we like the review you write (and it doesn't necessarily have to be full of praise for the reviewed product) then you will win free license(Except for Corporate/Site License) or discount for Rep2excel.

    Sample

    Learn More...

     
     
       
    ©2003-2011 Lion Soft Ltd. All Rights Reserved.

    Oracle logo are trademarks or registered trademarks of Oracle Corporation in the United States and/or other countries.