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