Sitemap

Amicuk Programming Answers

Formatting report in excel format

2015-10-11   Views:1

Advertisement

Hi, I have to generate report in excel format but I don't know how to format it for example to add a dynamic title, and to add a logo in the top of the excel sheet... any help.. thanks in advance.Hi, Oracle Portal Reports generated do not pick up the

Hi,
I have to generate report in excel format but I don't know how to format it for example to add a dynamic title, and to add a logo in the top of the excel sheet...
any help..
thanks in advance.

The replay answer
Advertisement
Hi,
Oracle Portal Reports generated do not pick up the foramting conditions which you would see in HTML/ASCII format .Hence ,TITLE ,FOOTER or number ,date formats wouldn't work in Excel format .Incase you needed formatted output ,you can use HTML/ASCII foramt.
Incase you want to use the EXCEL format.Save the Excel file and right macros to do so.
Thanks,
Anu

Go to See the other 3 answers

Issue while exporting report in Excel Format

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am facing problem while exporting the report in Excel Format. After analysis, I think that it could be due to two reasons, either we are using wrong versions of Jars, or we are using wrong API. Here is the code, approaches and problems we ar[More]

Need to convert AP Invoice Aging Report in Excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi, Need to convert AP Invoice Aging Report in excel format..there was an existing Invoice Aging report in AP and that was in paper format. That we need to convert to rtf template.. There was an other concurrent program called 'Invoice Aging Report ([More]

How to create a report in excel format having two tab

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have Business requirement where customer wants to create a report in excel format having two tab. Please let me know if it is possible? I am using 10.1.4.3.2 version of BIP. Thanks & Regards, Edited by: 862749 on May 20, 2013 7:36 PMI have[More]

Cells merge issue when extracting webi report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, We have some WEBI reports in BO XI 3.1. The reports have header where we are showing report name and some values which user selects in prompt. Now the issue is that when we save our webi report in excel format, many cells get merge. I hav[More]

Help me to download my report in excel format.

Category:DefaultRelease time:2015-10-11Views:130

Here is my code below. On selection screen I am giving three inputs. And There are two radio buttons present on my selection screen. first one is for display the report. second button name is generate(to export the report). Clicking on the generate r[More]

Subject: How to get MB5B report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Dear experts, Please help me how I get automatically MB5B Report in excel format. In Layout there is no option to convert excel format. regards, rss Edited by: rs_sharma on Jun 26, 2011 10:16 AMDear experts, Please help me how I get automatically MB5[More]

How can i convert oracle report in excel format using 8i

Category:DefaultRelease time:2015-10-11Views:130

hi, I want to convert oracle report in excel format using 6i reports. please give the solution with emp table. millons of thanks in advance.You'll have to use the destype DELIMITEDDATA to render your Report in CSV format. Then set the mime type to Ex[More]

Unable to print xml publisher report in excel format in R12

Category:DefaultRelease time:2015-10-11Views:130

Hi All, We are unable to print xml publisher report in excel format in R12. We were able to see the excel output but it's printing junk characters while printing and it's printing without any issue with PDF format. Please let me know how to fix this[More]

Unable to save webi report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have a question. I recently upgrsded my internet explorer from IE 7 to IE 8. Previously, i was able to save webi reports in excel format without any issues.Even after upgrading to IE version8, i was able to save webi reoprts to excel withou[More]

How to send ALV Report in excel format from SAP

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, We are using SAP 4.7 and using different SAP reports.Now I want to send SAP ALV report in excel format directly from SAP in background.Now we send these reports in background weekly by using autimetic scheduling but this is PDF format.Now I[More]

Urgent- o/p of report in excel format

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want to generate o/p of my report in excel format. Please send me the sample code for it at [email protected] Thanks in advance bhushanRajesh, yes, with BI Publisher (formerly known as XML Publisher) it's easy. But with Reports you don't ne[More]

Hot
When I have the downloads window open and I close the browser window, the next time I reopen the browser while the downloads are still going, it returns me to the last page I was on. All previous versions of Firefox would return me to my homepage whi [More]
My Konica Minolta printer BizHub Pro1200 is no longer printing after the update of the latest OS 10.6.8, the print queue is just sitting there with the Paused message, it won't print even when you try to resume the print, keeps getting back into the [More]
I received the following pop-up after receiving and following instructions on how to open a PDF file in OS 10.9 using a Firefox browser:  Adobe Reader cannot show documents in this browser. We are sorry, but Adobe Reader is unable to show documents i [More]
Hi I am using function module 'BBP_EXTREQ_INBOUND' to create shopping carts in an ABAP program. It works well and the shopping cart is created. My question is when you go into the SRM Portal and check the data everything is populated ecept the sectio [More]
I have old family movies on VHS tape that I want to edit on iMovie. What is the best CODEC format to have these tapes converted for use in iMovie?If I was having a third party do it, I would probably ask them to use the DV codec. Many of us  do this [More]
I run Xfce with no desktop icons, so I have no use for the ~/Desktop folder, which I've removed.  I've noticed that occasionally the Desktop folder will reappear in my home folder.  I saw a thread where a user claimed they saw this behavior after cli [More]
I know that we are way behind in terms of Livecycle ES versions, but we have recently installed Livecycle ES2 (9.0) on a set of new Websphere 7 servers. All seems to be progressing will in terms of systems integrating with the new servers, but we hav [More]
I look in my Dreamweaver pages and they look perfect. I check them in Internet Explorer and they look perfect.  But when I put it up and check it on the website, all the text is bold.  I checked my CSS code, my page Code, and can't find anything to t [More]
I would like to know how I can use the ICC profile of the photolab where I will print my photo's. I have downloaded the profile, but I can't change it in Photoshop Elements (11) Could somebody help me with this issue? Thank you.Hello Nick, sorry, I c [More]
Hello, i've configured Audit Policy via GPO and when i run RSOP on the server 2008 R2 i get X with the error "the policy engine did not attempt to configure the setting For more information, see %windir%\security\logs\winlogon.log on the target machi [More]