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

2 votes204 views2 answers
Commenting on C#
C#
1 vote200 views1 answer
Net.ServicePointManager.SecurityProtocol .net framework 4
C#
3 votes194 views1 answer
How consider the first caracter in Split c#
C#
1 vote209 views1 answer
Make string
C#
0 vote201 views3 answers
Loops in coding
C#
1 vote205 views1 answer
How to detect mouse click in c#
C#
0 vote225 views1 answer
How to access path position variable in unity
C#Unity
0 vote203 views1 answer
C# EDSDK control lens
C#
3 votes177 views1 answer
Unity desactivate collider
C#
0 vote191 views1 answer
Using selected item in listbox c# to fill texbox
C#