//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //Worksheet view settings. IWorksheetView sheetView = worksheet.SheetView; sheetView.DisplayFormulas = false; sheetView.DisplayRightToLeft = true; sheetView.GridlineColor = Color.Red; sheetView.Zoom = 200; // Save to an excel file workbook.Save("ConfigureWorksheetView.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Worksheet view settings. Dim sheetView As IWorksheetView = worksheet.SheetView sheetView.DisplayFormulas = False sheetView.DisplayRightToLeft = True sheetView.GridlineColor = Color.Red sheetView.Zoom = 200 ' save to an excel file workbook.Save("ConfigureWorksheetView.xlsx")