custom repot output required in excel format. limited to 65000 lines only

Anjum Saeed · Aug 13, 2025 8:40AM

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

Anjum Saeed · Aug 18, 2025 10:15AM

Hi Riyaz,

yes, your answers are also helpful, i adopted this solution, suits me.

Riyaz Ali-Oracle · Aug 13, 2025 4:23PM

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:

Thanks,
Riyaz Ali

Anjum Saeed · Aug 18, 2025 8:56AM

I tried by changing the report default format to "Excel".

it works for me.

Anjum Saeed · Aug 18, 2025 8:58AM

Riyaz Ali-Oracle · Aug 18, 2025 10:12AM

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 https://community.oracle.com/customerconnect/kb/articles/1-accepted-answer

Thanks,
Riyaz Ali

Oracle Analytics Publisher Forum