Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Exporting to Excel & Word Wrap

Received Response
122
Views
3
Comments
Tristan Hindes-14952
Tristan Hindes-14952 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

I want cells with longer text to wrap automatically when I export an analysis to excel 2010.

Content

I have a built an analysis that pulls in requisition user comments.  I am trying to export the information to excel with the cell width of that column fixed so it wraps the text, vs having a extremely long column.  These report will be delivered using an agent and I don't want my end user to have to open and adjust the width of the cell each day when the report is delivered.

 

Any thought/ideas on how to solve this issue.

 

Thanks

Tagged:

Answers

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    Have you looked at a B,I publisher solution 

  • Arun Raj
    Arun Raj Rank 5 - Community Champion

    You can create a BI Publisher report using RTF Template / Excel Template. You will have more control over the size of columns, text-wrapping etc.

    Thanks,

    Arun

  • Ramesh Nakka
    Ramesh Nakka Rank 4 - Community Specialist

    Hi

    Can you try inserting a Analysis in a dashboard and schedule it through Agent?

    OR

    User has to create a customized setting with macro for all formatting. Once you set it will be embedded in excel.you would just need to click one time entire format.

    No need to do manual formatting..

     

    Regardrs,

    Ramesh