//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]; //Set paper scaling //Method 1: Set percent scale worksheet.PageSetup.IsPercentScale = true; worksheet.PageSetup.Zoom = 150; //Or Method 2: Fit to page's wide & tall //worksheet.PageSetup.IsPercentScale = false; //worksheet.PageSetup.FitToPagesWide = 3; //worksheet.PageSetup.FitToPagesTall = 4; // Save to an excel file workbook.Save("ConfigPaperScaling.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) 'Set paper scaling 'Method 1: Set percent scale worksheet.PageSetup.IsPercentScale = True worksheet.PageSetup.Zoom = 150 'Or Method 2: Fit to page's wide & tall 'worksheet.PageSetup.IsPercentScale = False 'worksheet.PageSetup.FitToPagesWide = 3 'worksheet.PageSetup.FitToPagesTall = 4 ' save to an excel file workbook.Save("ConfigPaperScaling.xlsx")