Better Excel Output

Rainer Willems from our German office has come up with a way to allow you get formulas into your Excel outputs from an RTF template, its a neat idea. It needs some thought up front about where data is going to be rendered in the Excel output, but thats easy enough to find out, just run the template to Excel et voila.
You can check out the details here

http://www.oracle.com/global/de/community/bip/tipps/rtf_to_excel/index_en.html

and for German readers

http://www.oracle.com/global/de/community/bip/tipps/rtf_to_excel/index.html

Just one drawback, that Rainer mentions, once down this path with an RTF template its forever a 'Excel' output template. Thats unless you are on 10.1.3.4 Standalone or above when your template becomes self aware of what its being run for e.g. PDF, RTF or Excel. Then you can add some logic e.g if output != 'Excel' then hide this section of the template end if. More on that another day.

Comments:

I appreciate the great article you provide in your entries. I’ll bookmark your website and have my friends visit in your site often. I am quite sure they will read a lot of new stuff in your site than anywhere else!

Posted by Click here on December 09, 2009 at 08:18 AM MST #

I am using an RTF template and creating Excel output. How do I get the output to recognize features such as Landscape output and sizing cells such that it fits contents? When I output to pdf, all is fine. Thanks.

Posted by Karen on February 16, 2010 at 11:48 PM MST #

It's quite possible that there exist an almost infinite number of Universes. We have no idea what lies beyond the edge of this collection of stars and materials we call The Universe.

Posted by Maia Crytzer on September 25, 2010 at 08:05 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today