Rows to repeat on top when Printing(excel ,pdf)

Aspose.Cells Product Family
1

Hi, I have a requirement to repeat header rows on pages based on Table data when printing.

Explanation: In an excel if we have two tables with Table 1 column names (A,B,C,D) and table 2 columns names as(x,y,z) and each table has more than 100 lines of data.Aspose_Issue_RepeatRowHeader_pdf.pdf (126.5 KB)

In PageSetUp i have set “Rows to repeat at top” $1:$2". which is repeating Table-1 columns row (A,B,C,D)on all pages, but is there an option to set Table-1 column row (A,B,C,D) to be repeated only for Table-1 set of data and Table-2 column rows(x,y,z) to be repeated only for Table-2 set of data when printing .

2

@pramodh203,

Well, you need to to place/split Table-2 on separate sheet. For example, first sheet will only have Table-1, second sheet will have Table-2. This way, you will set the option Rows to repeat at top of each sheet’s PageSetup differently.

Hope, this helps a bit.

3

@Amjad_Sahi Thank you. It worked

4

@pramodh203,

Good to know that the suggested workaround works for your needs. In the event of further queries or issue, feel free to write us back and we will be happy to assist you soon.