//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); //Use sheet index to get worksheet. IWorksheet worksheet = workbook.Worksheets[0]; // freeze pane worksheet.FreezePanes(5, 5); // Set frozen line color as dark blue. worksheet.FrozenLineColor = Color.DarkBlue;
' Create a new Workbook Dim workbook As New Workbook 'Use sheet index to get worksheet. Dim worksheet As IWorksheet = workbook.Worksheets(0) ' freeze pane worksheet.FreezePanes(5, 5) ' Set frozen line color as dark blue. worksheet.FrozenLineColor = Color.DarkBlue