//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\PageSetup Demo.xlsx"); workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.PageSetup.CenterFooter = "&P"; //Set first page number, default is p1. worksheet.PageSetup.FirstPageNumber = 3; //save to an excel file workbook.Save("configfirstpagenumber.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim fileStream = GetResourceStream("PageSetup Demo.xlsx") workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.PageSetup.CenterFooter = "&P" 'Set first page number, default is p1. worksheet.PageSetup.FirstPageNumber = 3 ' save to an excel file workbook.Save("configfirstpagenumber.xlsx")