Split worksheets multiple times

deahayes

We are using BI Publisher Excel template (97-2003) . We have data that can exceed the row limit of 65k rows. This template has 3 tabs/worksheet each can exceed 65k. How can we generate tabs automatically after ever 65,000 rows?

I started with following xml but nothing is happening on template. Inserting an example.

TEST.xls

EzequielC-Oracle

Hi Deahayes,

Please, check if this MOS document would help you:

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

Regards,

Ezequiel.

deahayes

Thanks, thats the document I followed, Its confusing, it splits by department , I want to spilt by row count.

Gianni Ceresa

@deahayes ,

Could you stay only on a single thread for this?

You have the same thread in the Publisher category of the MOSC forum (https://community.oracle.com/mosc/discussion/4558149/split-excel-template-into-multiple-tabs-after-65-000-rows#latest). It is still a form of double-posting as both forums are Oracle owned forums.

Pick one and stay on it till you get what you look for.

deahayes

Sorry didnt realize they were on same platform

deahayes

Hi

I tried 1352000.1 but I have 3 sheets in my template and this is overwriting the other sheets. I want to count rows from each sheet and split each that way if over 65k rows