Author: Tomas Rutkauskas

How to split and freeze rows and columns in Excel

Answer:

1   { ... }
2   ExcelApplication1.Connect;
3   ExcelApplication1.Workbooks.Add(Null, 0);
4   ExcelApplication1.ActiveWindow.SplitColumn := 5;
5   ExcelApplication1.ActiveWindow.SplitRow := 10;
6   ExcelApplication1.ActiveWindow.FreezePanes := True;
7   { ...}