//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\PageSetup Print Title Rows.xlsx"); workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; //Set rows to repeat at top worksheet.PageSetup.PrintTitleRows = "$5:$10"; // Save to an excel file workbook.Save("ConfigPrintTitleRows.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim fileStream = GetResourceStream("PageSetup Print Title Rows.xlsx") workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Set rows to repeat at top worksheet.PageSetup.PrintTitleRows = "$5:$10" ' save to an excel file workbook.Save("ConfigPrintTitleRows.xlsx")