[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1563
  • Last Modified:

Delphi Excel Automation- Freezepanes

I'm using Delphi7 with excel 2000 oject automation.
Having created a workbook and inserting data
I need to set freeze pane at cell (2,2 )
can someone help me given the following delphi code

var
  xlapp: TExcelApplication;
  sheet:olevariant;
  RangeE: variant;
begin
  xlapp := TExcelApplication.Create(Self);
  xlapp.Connect;
  xlapp.Workbooks.Add(NULL, 0);
  xlapp.Workbooks[1].Activate(1);
  sheet:= XLApp.Workbooks[1].Worksheets[1];
  sheet.Name := 'FreezeThisOne';

0
meyerworks
Asked:
meyerworks
  • 2
1 Solution
 
saravananvgCommented:
Hello Sir,

  You can freeze panes using the following command

ExcelApplication1.ActiveWindow.FreezePanes:= true;

with regards,
padmaja.
0
 
saravananvgCommented:
Hello Sir,

  check the following site for more information.

http://www.koders.com/perl/fid4E1343EB5749DD8A973DD522E2C6107AD85E30D6.aspx

with regards,
padmaja.
0
 
meyerworksAuthor Commented:
Perfect. Thank you padmaja.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now