Report output in excel format.

Advertisement

Dear Friends,
I have created a report in character mode and I want to store the output of that report into an excel file. So that data of each column with heading will be stored in seperate coulmns(with each row of output in each row in excel file).
Output as follows:-
EMPNO ENAME DEPT
0099 JOHN ART
0011 SMITH ENGG
and so on...
I hope I will get the solution quickly.
Thanks in advance.
Sanjeev Bhattacharya

Advertisement

Hey Sandeep,
I am working on a similar format for a report and if possible can you please give me some guidelines. I have initially created reports using XML Publisher, but for those , the output preview format was PDF. So, if I select the preview format as EXCEL will it give me output in Excel and for this to happen, how do I define the rtf template. I believe the working will be same as for PDF, create a rdf report, get output in XML and apply the template to get the data in Excel or there is something different to this.
Thanks,
Sunil

November 30, -0001

Oracle reports output in excel format does not display the graphs

Oracle reports output in excel format does not display the graphs: "linked image cannot be displayed". The output file in PDF format the graph is supported.Do you have any header and footer on your template? If you have any header and footer the

Report output in excel format.

Dear Friends, I have created a report in character mode and I want to store the output of that report into an excel file. So that data of each column with heading will be stored in seperate coulmns(with each row of output in each row in excel file).

XML Publisher report default output in Excel format.

Hi, We have defined one concurrent program whose output format is text, this concurrent program executable is PL/SQL and in this PL/SQL program we are generating XML data and displaying XML using below fnd_request. l_conc_id := FND_REQUEST.SUBMIT_REQ

How to Generate HTML Report Output in Excel

Dear Experts, How to convert HTML report output in Excel. I have reports which output is coming in HTML format & the same I want to use in Excel. So tell me how I can covert the same in Excel. Thanks Sudhirhello, in your case, you might want to make

How to get Report Output in csv format

Hi, How can i get report Output in csv format, can any one tell me the word used for output type to get output in csv format. i have used XLS output type but it opens in excel format. conc.addLayout(appCode,concReqCode,"en-US","US",XLS

Problem when dowloading the ALV report output to Excel Sheet.

Hi , I am dowloading the ALV report output to Excel Sheet. There is field Condition Unit(KOMP-KMEIN) in the output of the ALV, this has values PC and CSE , but when I download to Excel Sheet, CSE is appearing as CSE ,but PC is appearing as ******. Ca

Output in Excel Format Issue

Hi all, I am not able to view the output in EXCEL format after registered the RTF file in the XML Publisher Administrator to run as a concurrent program. I am wokring in XMLP 5.6.2 and Microsoft Office 2003. When i preview the output as EXCEL in the

How to retrieve complete report output in HTML format

Hi, I'm looking for how to retrieve complete report output in HTML format. I have tried the following and it only give me first page of the report output where in the actual report output should be 5 pages. Is there something I'm missing. CallbackOpt

Sending report output to Excel

Dear buddies I'm using OLE Object in my report to send its output to excel. I find this way from an example at the same forum. But I feel that this example is for very small sized reports which have to send a few cells to excel because in this method

Issue while downloading the alv report output in spreadsheet format .

Hi, I have a report output, whenever I try to download it in the spreadsheet format to my desktop, I get the following issue: Say the correct material number is 10833340001218999 or 10030000063207001 (This appears in the report output) But in the exc

Change the Locale settings when scheduling the report with an Excel format?

Hi, My reports have been scheduled with Excel format, however, when the report is viewed in Excel, the date fields are in the format "mm/dd/yyyy" i.e. English(United States) and they need to be in the format "dd/mm/yyyy" i.e. English (

Send Report Output to Excell?

Hi all, can anyone say me, how can I send the output of Report to the Excell Worksheet? RegardsHi Leonid, you can try this: In AFTERPARAMETERFORM trigger: myfile TEXT_IO.FILE_TYPE; begin myfile := TEXT_IO.FOPEN(:DESNAME, 'W'); TEXT_IO.PUT(myfile, 'fi

CF Report Builder and Excel format

Hi Everyone, I was trying to display a report in excel format in report builder. It shows the data, but I do not find the print button options, whereas I can see it with other formats. Is this the way it is, or do I need to format anything more withi

WAD report export to excel formatting not preserved

Hi, when i export BI 7.1 WAD template to excel and copy to another excel sheet cell formatting changes.color formatting is not preserved when we copy to another excel sheet.I tried resetting the "preserve visual appearance of workbook" to the ex

How to Schedule Report Output in EXCEL (.cvs) format for Planning 11.1.2.1

Hi all, I'm using Planning 11.1.2.1 for entering data and generating reports manually via Workspace. I wanna set up an automation process with a batch scheduler. I've gone over the documentation. I've read about creating batches first then scheduling

Sending report output to Excel worksheet- Why all labels R put in one line?

We need to export data from Oracle database to MS Excel work sheet. We developed a report and put all required things in the report. Set DESFORMAT and DESNAME parameters accordingly. Every thing works fine. But all the labels at the start of report a

Pritn foramt for the report output in Landscape Format

I have a question about how we can get a spool output switched to fit to a Landscape format - it is currently printing format 90x120 on a Letter size ( Portrait format ) - it's a report outputHi You can write the code during the PRINT COMMAND  to spe

Print Report Output in PDF Format

:-) Hiee E'body I generated the output of a Report(developed in Report Builder 6i) in PDF format. The output file is created properly and the PDF file gets displayed on the screen in proper format but when i try to print the PDF file it gets printed

Report header on Excel Sheet

Hi to all there, I am generatating my report output in excel format, I am getting the records but my report header is not coming on Excel. I have developed this report using reports6i. can anybody help me. Thanks in advance Manvarits not the "layout

Saving report in excel format

I need to save a report directly to excel format. The user does not want to open a delimited file in excel. After a lot of trials I got excel.prt file which supposedly saves the report in excel format directly from the PRINT TO FILE option. But I am