X

An Oracle blog about BI Publisher

  • RTF
    July 7, 2009

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.

Join the discussion

Comments ( 3 )
  • Click here Wednesday, December 9, 2009
    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!
  • Karen Wednesday, February 17, 2010
    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.
  • Maia Crytzer Sunday, September 26, 2010
    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.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.