Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Use .xlsx Excel templates in BI Publisher

Submitted
2097
Views
32
Comments
timvanlith1
timvanlith1 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Description

Currently only .xls Excel templates are available. The idea is to support .xlsx Excel templates as well in BI Publisher.

Use Case and Business Need

If .xlsx templates are supported, all new features in Microsoft Excel can be used. For example the Auto Save function in combination with OneDrive.

 

It would also become possible to use password protection for the Excel output generated from these Excel templates.

See the following idea: https://cloudcustomerconnect.oracle.com/posts/5d863e2d1f

As mentioned there: Excel output in .XLS format generated from Excel templates do not support password protection.

More details

It is currently not possible to use password protection for Excel output generated from .xls Excel templates.

Also, new Excel features like AutoSave are not available when working with .xls Excel templates.

Original Idea Number: d7c6d62c3e

Tagged:
80
Up
80 votes

Submitted · Last Updated

«134

Comments

  • Tessy
    Tessy Rank 2 - Community Beginner

    .xls is also just old. Where .xlsx is newer so better aquited for current threads and usages.

  • Craig Manetta
    Craig Manetta Rank 1 - Community Starter

    Now data has been growing in our database we are getting scenarios whereby downloads are failing due to the tiny number of rows that are available in the very old XLS file format.

    Oracle needs to update as a matter of urgency!!!

  • Jacob Thompson
    Jacob Thompson Rank 2 - Community Beginner

    This would be very helpful

  • inge niesink
    inge niesink Rank 1 - Community Starter

    This would be very helpful if BI publisher can generate output in .xlsx!

  • Rich Merkel
    Rich Merkel Rank 5 - Community Champion

    this would be good

  • Bertrand Renaudin-194281
    Bertrand Renaudin-194281 Rank 1 - Community Starter

    This would help break the 65k limitation while still being able to use a native excel template to customize standard reports from financials for example

    As a workaround, using rtf templates with excel(xlsx) output is fine for 65k limitation break, but does not allow actual excel fine output, with dynamic pivot table embedded, and so much things excel can do...

    Please consider making this upgrade!

  • Rakesh Kumar-189257
    Rakesh Kumar-189257 Rank 3 - Community Apprentice

    Definitely Need, If this happens, we can use some xlsx feature in template which enhance the look of report.

  • Ahmed Maher K.
    Ahmed Maher K. Rank 6 - Analytics Lead

    Will be very useful feature. Vote up.

  • Sarvesh
    Sarvesh Rank 1 - Community Starter

    This is needed and .xlsx is supported with rtf and should also be supported with excel template.

  • KDR
    KDR Rank 3 - Community Apprentice

    This is definitely needed, and will help overcome the .xls 65k row limitation and allow us to embed formulas directly into the template, for which we can not do inside an RTF template.