//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1:B5"].Value = new object[,] { {1, 2}, {3, 4}, {5, 6}, {7, 8}, {9, 10} }; //Add page break sheet.HPageBreaks.Add(sheet.Range["B3"]); sheet.VPageBreaks.Add(sheet.Range["B3"]); // Save to a pdf file workbook.Save("ConfigurePageBreaks.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) sheet.Range("A1:B5").Value = New Object(,) { {1, 2}, {3, 4}, {5, 6}, {7, 8}, {9, 10} } 'Add page break sheet.HPageBreaks.Add(sheet.Range!B3) sheet.VPageBreaks.Add(sheet.Range!B3) ' save to a pdf file workbook.Save("ConfigurePageBreaks.pdf")