Split and freeze rows and columns in Excel (Views: 28)
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; { ...} |