C# excel fix first row

// Fix first row
workSheet.Activate();
workSheet.Application.ActiveWindow.SplitRow = 1;
workSheet.Application.ActiveWindow.FreezePanes = true;
// Now apply autofilter
Excel.Range firstRow = (Excel.Range)workSheet.Rows[1];
firstRow.AutoFilter(1, 
                    Type.Missing, 
                    Excel.XlAutoFilterOperator.xlAnd, 
                    Type.Missing, 
                    true);

Source: stackoverflow.com

Similar codes

0 vote271 views1 answer
How to hide tree level button when no record found for devexpress child grid view in Winform c#
C#
-1 vote254 views1 answer
How to clear a dictionary in c#
C#
0 vote267 views2 answers
Calculated field gridview asp.net
C#
0 vote248 views1 answer
Exception meaning in .net core
C#
0 vote264 views1 answer
Visual studio c# color dialog
C#
3 votes261 views1 answer
Read folder c#
C#
1 vote252 views1 answer
C# winforms tooltip
C#
0 vote260 views1 answer
How to do division with button C#
C#
0 vote242 views1 answer
Calculator using single readline c#
C#
2 votes292 views1 answer
V-slot
C#