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

BI Report Output - How to get more than 65k rows in single tab in excel sheet

Thanigainathan R

We have a requirement to get all the data in single sheet in a excel output more than 65k rows.

Currently if the data more than 65k then data showing in next sheet.

We tried in XPT report and excel template but we couldn't achieve what we are looking for.

Find more posts tagged with

Excel

BI Publisher

Report Output

Accepted answers

Amrit

Hi,

If you want the output in a single sheet, then use the RTF template to generate the output in excel. It will give you .xslx output and all the data will populate in a single sheet.

Thanks and Regards,

Amrit

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Thanigainathan R

Welcome to FAW community.

This is an question to BIP forum. What version of BIP are you using? if it's support .xls file format its an limitation only.

BI Publisher Excel Template Layout Output is Truncating Data to 65536 Rows (Doc ID 1469264.1)

Regards,

Arjun

Amrit

Hi,

If you want the output in a single sheet, then use the RTF template to generate the output in excel. It will give you .xslx output and all the data will populate in a single sheet.

Thanks and Regards,

Amrit

wasim ashraf-Oracle

Hi Thanigainathan,

You can create multiple sheets in same excel file to get more than 65000 rows .

The following Note gives example on how to create such excel template :

Note 1352000.1 : BI Publisher: How to create Multisheet in Single Excel file using Excel Template.

Hope it helps you.

Thanks

Tejas GN

Hi,

I am facing the same issue with xpt template. The excel sheet is truncating at 60k rows. Any leads will be helpful.

Thanks