Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
custom repot output required in excel format. limited to 65000 lines only

custom developed report output to be in excel format. created a RTF rxcel format
oracle only allowing 'xls' format. limiting the record line upto 65000 only
Best Answer
-
Hi Riyaz,
yes, your answers are also helpful, i adopted this solution, suits me.
0
Answers
-
Hi @Anjum Saeed ,
Try the below:- Use CSV Format Instead:
Export the report as Data → CSV.
CSV files don’t have the same row limit and can handle hundreds of thousands of rows.
You lose formatting, but you retain all data. - Split the Report Output:
Modify your report logic to split data into multiple sheets or files.
For example, use filters to generate separate reports for each business unit or time period. - Use BI Publisher Bursting:
Use bursting to generate multiple Excel files based on a key (e.g., department, region).
Each file will stay under the row limit and can be emailed or stored separately.
Check this:
Getting around Excel xls output number of rows limitation? — oracle-mosc
Support XLSX template in BI Publisher to go further than 65k row limitation — Oracle Analytics
Thanks,
Riyaz Ali0 - Use CSV Format Instead:
-
Many Thanks, Riyaz Ali-Oracle
I tried by changing the report default format to "Excel".
it works for me.
0 -
0
-
Hi @Anjum Saeed ,
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
Thanks,
Riyaz Ali0