Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Support XLSX template in BI Publisher to go further than 65k row limitation

Use Case and Business Need
Hello,
XLS template only support 65000 row of data, we need you to implement xlsx template to go further than the 65k row limitation
thanks
Original Idea Number: 153c64487e
Comments
-
As a workaround, I've used a Layout Editor (.xpt) or RTF template and then enabled the Excel xlsx output type. This removes the 65k row limit of the older version of Excel template. However, BIP being able to accommodate the xlsx as a template type would be nice so the additional features of Excel can be utilized within the template as well.
1 -
it would be very helpful if we can open reports in xlsx.
1 -
this would indeed be helpfull
1 -
Gives us the opportunity to run certain report for a whole month in one report which is now not possible.
This is an terrible situation. We choose Oracle as the application because it promissed to be the best solution for our large range number of transactions.
How the report output is not able to handle these large numbers ......0 -
Fusion cannot remain in excel 2003 forever. I hope MS retire excel 2003!!
0 -
As a consultant for multiple large enterprises (over 100k employees), the ability to create BI reports with more than 65k row output is critical. Still relying on 2003 software with such limitations in 2022 does not give a good impression. We have more than 15 custom reports for Compensation reporting and have had to create workarounds to adapt to the growing volume of data, since the OOTB xls template does not meet our needs.
0 -
-
There is another way, which is a bit of a hack. Create an xlsx template in the normal way, rename this to xls and import into your report. This fools Publisher into thinking is has the 93-2007 style Excel.
When you download and open the generated xls, you will get a warning that the format does not match the extension, but now you can get reports containing up to 1,048,576 rows.
2 -
This issue has been known for many years now. Is it possible to advise if any development work being undertaken to support .xlsx templates at all?
0 -
Upvoted.. It will really help !!!
0