Page Break in case of Excel 2010

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

  • Hi Team -

    Can you someone please help me with this ticket?

    Thanks,
    Naveen.

  • edited December 2017

    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.

    Regards,

    Jeffrey Neneman

    OpenText - Analytics: http://www.opentext.com
Sign In or Register to comment.