Oracle Transactional Business Intelligence

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

Exporting to Excel & Word Wrap

Received Response
121
Views
3
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Have you looked at a B,I publisher solution 

  • 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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.