nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Anjum Saeed

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

Find more posts tagged with

Accepted answers

Anjum Saeed

Hi Riyaz,

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

All comments

Riyaz Ali-Oracle

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 Ali

Anjum Saeed

Many Thanks, Riyaz Ali-Oracle

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

it works for me.

Anjum Saeed

report-list.jpg

Riyaz Ali-Oracle

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

Thanks,
Riyaz Ali

Anjum Saeed

Hi Riyaz,

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