Hi, I have a excel, I need to write a program in c#.net to freeze both first row and first column in all the sheet . It is a windows based application any help plz.
I have created an Excel worksheet using automation from a VB.NET application. The worksheet is never made visible by the VB program. It is created and filled with data from a database and then some formatting is applied and the worksheet is saved. I need to know how to freeze panes in my VB program before the worksheet is saved so when the saved worksheet is opened, the column headings in the third row are not scrolled out of view when the user scrolls the data.