Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Thu Dec 20, 2018 2:53 pm

Hi,

is it possible to freeze rows or columns?

GH

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Fri Dec 21, 2018 3:14 am

Hi GH,

Thanks for your inquiry.
Please refer to following code:
Code: Select all
            spreadsheet1.ActiveWorksheet.FreezeColumn(ColumnNumber);
            spreadsheet1.ActiveWorksheet.FreezeRow(RowNumber);


Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 2638
Joined: Tue Sep 06, 2016 8:30 am

Fri Dec 21, 2018 5:28 am

Thank you!

merry Xmas and a happy New Year

GH

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Fri Dec 21, 2018 6:00 am

Hi GH,

Merry Xmas and happy New Year!
If there is any question while using our product, please feel free to contact us.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 2638
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.Spreadsheet