//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); //Use sheet index to get worksheet. IWorksheet worksheet = workbook.Worksheets[0]; // Set not to show horizontal gridlines worksheet.SheetView.DisplayHorizontalGridlines = false; // Set to show vertical gridlines worksheet.SheetView.DisplayVerticalGridlines = true;
' Create a new Workbook Dim workbook As New Workbook 'Use sheet index to get worksheet. Dim worksheet As IWorksheet = workbook.Worksheets(0) With worksheet.SheetView ' Set not to show horizontal gridlines .DisplayHorizontalGridlines = False ' Set to show vertical gridlines .DisplayVerticalGridlines = True End With