Mirror

Split and freeze rows and columns in Excel (Views: 100)


Problem/Question/Abstract:

How to split and freeze rows and columns in Excel

Answer:

{ ... }
ExcelApplication1.Connect;
ExcelApplication1.Workbooks.Add(Null, 0);
ExcelApplication1.ActiveWindow.SplitColumn := 5;
ExcelApplication1.ActiveWindow.SplitRow := 10;
ExcelApplication1.ActiveWindow.FreezePanes := True;
{ ...}

<< Back to main page