I was unable to freeze the top row in excel. I am using v11.2
Using the following line
excelWorksheet.DisplayOptions.FrozenPaneSettings.FrozenRows = 0;
Set FrozenRows to 1 and set excelWorksheet.DisplayOptions.PanesAreFrozen to True.
Hello,Mike!How do I freeze Row and Column in Infragistics.Excel V5.3 ??
I don't believe it was possible in that version. You will probably need to upgrade to a newer version to freeze rows.
Thinks! But our system used framework1.1,so can't upgrade to 2009.
There is other problem, worksheet name I use Chinese will be garbled。
For example："mysheet1:=mybook.Worksheets.Add('测试');",that will be messy code
Could you please help?
regards
by the way,mysheet1.name is OK.So the error in infragistics.Excel.BIFF8Writer.WriteWorkbookToFile(mybook,filename)??
Without upgrading, I don't believe there is any way to freeze rows or fix the Chinese character encoding issues. 5.3 was a very old version which had very limited capabilities and some bugs. You will need to upgrade if you want to do the things you are describing.