//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\RepeatTails.xlsx"); workbook.Open(fileStream); //Repeat the columns "I" at the left of each page when saving worksheet2 to pdf. IWorksheet worksheet1 = workbook.Worksheets[0]; worksheet1.PageSetup.PrintTailColumns = "$I:$I"; //Repeat the row 50th at the bottom of each page when saving worksheet1 to pdf. IWorksheet worksheet2 = workbook.Worksheets[1]; worksheet2.PageSetup.PrintTailRows = "$50:$50"; // Save to a pdf file workbook.Save("ConfigurePrintTails.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim fileStream = GetResourceStream("RepeatTails.xlsx") workbook.Open(fileStream) 'Repeat the columns "I" at the left of each page when saving worksheet2 to pdf. Dim worksheet1 As IWorksheet = workbook.Worksheets(0) worksheet1.PageSetup.PrintTailColumns = "$I:$I" 'Repeat the row 67th at the bottom of each page when saving worksheet1 to pdf. Dim worksheet2 As IWorksheet = workbook.Worksheets(1) worksheet2.PageSetup.PrintTailRows = "$50:$50" ' save to a pdf file workbook.Save("ConfigurePrintTails.pdf")