//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; //Set pages' data. sheet.Range["A1:J46"].Value = "Page1"; sheet.Range["A1:J46"].Interior.Color = Color.LightGreen; sheet.Range["A47:J92"].Value = "Page2"; sheet.Range["A47:J92"].Interior.Color = Color.LightYellow; sheet.Range["K1:T46"].Value = "Page3"; sheet.Range["K1:T46"].Interior.Color = Color.OrangeRed; sheet.Range["K47:T92"].Value = "Page4"; sheet.Range["K47:T92"].Interior.Color = Color.DarkOrange; sheet.PageSetup.PrintHeadings = true; //Set page order. Now the page order is p1-p3-p2-p4. Origin is p1-p2-p3-p4. sheet.PageSetup.Order = Order.OverThenDown; // Save to a pdf file workbook.Save("ConfigurePageOrder.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) 'Set pages' data. sheet.Range("A1:J46").Value = "Page1" sheet.Range("A1:J46").Interior.Color = Color.LightGreen sheet.Range("A47:J92").Value = "Page2" sheet.Range("A47:J92").Interior.Color = Color.LightYellow sheet.Range("K1:T46").Value = "Page3" sheet.Range("K1:T46").Interior.Color = Color.OrangeRed sheet.Range("K47:T92").Value = "Page4" sheet.Range("K47:T92").Interior.Color = Color.DarkOrange sheet.PageSetup.PrintHeadings = True 'Set page order. Now the page order is p1-p3-p2-p4. Origin is p1-p2-p3-p4. sheet.PageSetup.Order = Order.OverThenDown ' save to a pdf file workbook.Save("ConfigurePageOrder.pdf")