How to generate Excel files in Oracle Reports

Advertisement

Hi,
I've already built a JSP using oracle reports and Deploy on the report service. I also add a button to the left of the JSP.The next thing I want to do is:when user click on the button, the system will prompt a excel file contains the same content as the JSP file.
Can anybody teach me how to do? Thanks very much

Advertisement

Hi Ni,
It may not be possible to see the output of the SAME report in Excel as well. You will have to design another report which can open in Excel. You can follow this demo:
http://otn.oracle.com/products/reports/htdocs/getstart/demonstrations/excel/index.html
Then you can add an action to your button so that it opens the new report in a new browser window. This new browser window will open MS Excel and show the report inside Excel.
The reason that you can't output the SAME report in HTML as well as MS Excel is because we use page contentType to specify the application that the browser should open the document in (the application can be MS Word, MS Excel, etc). For example,
<%@ page contentType="application/vnd.ms-excel" %>
But we can only specify one contentType for a JSP, so the report can either be viewed as HTML or inside MS Excel.
Navneet.

October 11, 2015

How to generate Excel files in Oracle Reports

Hi, I've already built a JSP using oracle reports and Deploy on the report service. I also add a button to the left of the JSP.The next thing I want to do is:when user click on the button, the system will prompt a excel file contains the same content

How to generate Excle file for a report runningin a Batch job

Hello All, Can we generate Excle file for a report running in a Batch job. Kindly send reply to     [email protected] Thanks in Advance. Cheers, SundeepDear Sundeep, I'm providing you with the following piece of code ... Its working fine for me ... h

Help Required:How Upload Excel file Into Oracle Table Using PLSQL Procedure

Please Help , Urgent Help Needed. Requirement is to Upload Excel file Into Oracle Table Using PLSQL Procedure/Package. Case's are : 1. Excel File is On Users/ Client PC. 2. Application is on Remote Server(Oracle Forms D2k). 3. User Is Using Applicati

How to create .csv file from ABAP report

Hi We have a requirement to generate .csv file from abap report. Currently user saves data from abap report to spreadsheet(.xls format) in desktop.  Then opens excel file and save as .csv format.  Need option to save directly in .csv format instead o

Step- by- Step on How to Load Excel data into Crystal Reports?

Hi Friends,                   Can anyone send me a Step- by- Step on How to Load Excel data into Crystal Reports? Pls help me. Thanks in Advance. VijayIt's also important to 'prep' the excel file prior to connecting to it. Give the data tab a meaning

How to Zip Excel files using File Adapter?

Hi, We have tried to ZIP the Excel file with  PayloadZipBean in File adapter. But we faced some issue while zipping. We have seen some zunk data in excel file after zipping with PayloadZipBean. Someone please help how to zip Excel files in PI with Fi

How to generate output file of a certain report in a specified directory

Hello everyone, I wanna know how to generate the output file of a certain report in a specified directory. Now, the output file directory = /produits/OA/OAS/production/prodcomn/admin/out/PROD_us15k1bp/ I wanna to generate the output file of a report

How to upload excel file in application server??

Hi, How to upload an excel file into internal table in background mode from application server? ThanksHi vipin, check this it may help you... hope below links helps you Export the report list to Excel Sheet http://www.sapdevelopment.co.uk/file/file_u

How to attach Excel file in Mail Receiver Adapter?

Hello Experts, In R/3 coding I have Internal Table data available for which i have to generate an Alert mail with Excel file attachment. This is the scenario of Proxy sender to Mail Receiver. but I don't know how to convert the Internal Table data in

Error while generating XML file from rdf report.

Hi All, we are having a rdf report that displays images retrieved from data base. I need to convert this report to xml report(using rtf template). when i tried to run the report after changing the output of the concurrent program to "XML", i am

How to generate XSD file for XML schema adobe form

Hi, I want to generate XSD file for XML schema interfaces adobe forms. How can I do it. Where I can do it..or who will provide this file.. Thanks Ram Edited by: Ramesh ram on Feb 23, 2010 6:33 PMAaaaah, my mistake, sorry for that. Of course you shoul

Generate Excel File using Java

Hi, could any one tell me how can I create an Excel file using java. I can create the file using PrintWriter and other IO classes. But how do I insert the data in to different cells and rows. Any help would be greatly appreciated. Thanks in advance f

DiagTool- how to generate the file

Hi can some one tell me how to use the diagtool i read the note , its says Dowload the attached tool (diagtool.zip) and execute it according to the root instructions: go.bat <config_file> <path_to_configtool>  (Windows and IBM iSeries) whre ca

How to generate Income Statement from Crystal Report

Hi, Experts, I have: SAP BUSINESS ONE 2007A CRYSTAL REPORT 2008 I have a problem with generating Income Statement related reports from CRYSTAL. For example, My revenue accounts are: '411000-00-00' and '412000-00-00', my expense accounts are: '510000-

How to generate mmx file in 10g or 9i?

I am in the process of migrating Forms from version 6 to 10g. I compliled mmb files without any error, but how do I generate mmx file in 9i or 10g? I used to be able to generate mmx file in Form version 6 through: File -> Administration -> Compile F

How to read excel file in document library and store excel content in sql table

Hello, Can anyone help me how to read the excel file present in document library and store the content inside excel into sql table? Please let me know the ways to acheive this. Feel free to give your suggestions. Thanks, Cool DeveloperHi! this code i

How to generate EXCEL formate

Hi, We working XML Publisher .... We are following the user's guide. According to that we came upto viewing and updating a template(in Templete Manager) Can u tell me how to generate RTF and EXCEL formate in appsyou have to wait till Jan 2007, untill

How to grant access to a Oracle Report  Program

Hi hussein, I am checking/debugging our clients registered customized report program setup. I want to grant the program to my ID so I can test print and see its output. The steps I followed are the ff: A. System Administrator resp: Concurrent Program

How to Run Batch files from inside Reports.

Hi All, I have 2 questions. 1) How to change the direction of the reports with Arabic orientation i.e Right to left Change without changing the registry. 2) How to execute a batch file from report or before execution of the report i.e before opening

Import from Excel file to Oracle Db

Dear all, I am not having DBA privilege.And I cant use export utility. I want to import the datas from Excel file through query builder. I Know there is a option in query builder. But i dont know how to do? Plz help... Thanks.Hi, If you are very spec