//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(2, 2); // freeze trailing pane worksheet.FreezeTrailingPanes(2, 3);
' Create a new Workbook Dim workbook As New Workbook 'Use sheet index to get worksheet. Dim worksheet As IWorksheet = workbook.Worksheets(0) With worksheet ' freeze pane .FreezePanes(2, 2) ' freeze trailing pane .FreezeTrailingPanes(2, 3) End With