Excel automation problem

  • Thread starter Thread starter Kalle
  • Start date Start date
K

Kalle

During Excel automation in VB one can lock lines for
scrolling by the following code

ActiveWindow.FreezePanes = True

what would be the equivalent in c#?

Is it some way to convert or generate Excel Macron in C#
rather than in VB?

Greateful for answers!
Kalle
 
Kalle,

You would use the same property assignment in C#. However, VB makes
late-binding very easy (which I assume is what you are doing). In C#, it
would be easier if you placed a reference to the "Microsoft Excel Object
Library" in your project, and then cast the ActiveWindow instance (which is
off the Application object you will create) to the appropriate worksheet
instance.

Hope this helps.
 
Back
Top