Page Break in case of Excel 2010

Naveen V M
Naveen V M
edited February 11, 2022 in Analytics #1

Hi Team -

Is there any way to configure the number of rows that can be extracted in Excel worksheet when it is extracted through spudsoft emitter. By default, it extracts 1,048,576 rows. I want to reduce the rows extracted in a single sheet.

Thanks,
Naveen.

Comments

  • Naveen V M
    Naveen V M
    #2

    Hi Team -

    Can you someone please help me with this ticket?

    Thanks,
    Naveen.

  • jneneman
    jneneman E
    edited December 12, 2017 #3

    Hi Naveen,

    Would you be able to make the change from the design side?

    In the outline select Body > Table. Then hit properties, select Advanced > Page break Interval.

    You can set the page break interval to a comfortable value before the xls limitation of 65,536 rows. Once it hits the page break interval, the next row of data will be populated on the next worksheet.

    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs