I was unable to freeze the top row in excel. I am using v11.2
Using the following line
excelWorksheet.DisplayOptions.FrozenPaneSettings.FrozenRows = 0;
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.
by the way,mysheet1.name is OK.So the error in infragistics.Excel.BIFF8Writer.WriteWorkbookToFile(mybook,filename)??
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
I don't believe it was possible in that version. You will probably need to upgrade to a newer version to freeze rows.
Hello,Mike!How do I freeze Row and Column in Infragistics.Excel V5.3 ??