Multiple Horizontal And Vertical Page Breaks

Aspose.Cells Product Family
1

Hi,

I have 4 Grid in my Excel sheet . in a form of 2*2 matrix. i want each grid to be printed on a different page . can this be done using multiple HorizontalPageBreaks & VerticalPageBreaks. As we can have multiple HorizontalPageBreaks & VerticalPageBreaks.

EX: Excel is like

Grid1 Data Grid2Data

Grid3 Data Grid4Data

i want when i print my excel each grid should be printed in a different page.

2

Hi,


Please see the document/ article for your reference:
http://www.aspose.com/docs/display/cellsnet/Managing+Page+Breaks

Well, you may use “Add” method of HorizontalPageBreakCollection/ VerticalPageBreakCollection multiple times to add different page breaks (both horizontally and vertically).

If you still could not evaluate, kindly provide us your expected Excel file that you may create in Ms Excel manually, we will check and help you on how to insert different page breaks accordingly.



Thank you.