How to reduce oracle excel output size?

Asked By Janet Campbel 90 points N/A Posted on - 10/17/2012

Hello experts,

How to reduce oracle excel output size?

Can you teach me in a way of step by step process for me to easily understand and apply the possible solution for this kind of situation?

I am just curious on how to get this done immediately.

Thank you.

 

• Status: Open
• Question Views: 1321
• Answer Count: 2
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Sharath Reddy

Go To Solution

Answered By June Antonia 5 points N/A #164947

How to reduce oracle excel output size?

Hi,

If you want to reduce Oracle's Excel output size, you should visit this site.

It will help you with your problems.

Thank you.

About June Antonia

Questions
0

Answers
98

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 10/17/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #164948

How to reduce oracle excel output size?

There is a way of reducing the file size of Microsoft Office Excel by directly downloading a request or analysis to native Excel format instead of mhtml.

The procedure below is not recommended by Oracle since there is still a bug that hasn’t been fixed yet. It has been tested to work on Oracle Business Intelligence Enterprise Edition 11.1.1.6.

• Navigate to the path “<MiddlewareHome>Oracle_BI1bifoundationwebmsgdbmessages” and then edit the file “viewscontrolmessages.xml”.
• Change all instance of Format=mht to Format=excel.
• Login to Oracle Business Intelligence Enterprise Edition then go to Administration, Reload Files and Metadata.

You will now be able to export the reports in “.xlsx” format with less disk space consumed.

This doesn’t require restarting of services. If you want to see an example, Please refer here.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 11/14/2012
• Question Category: Oracle Database