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

9 votes258 views5 answers
Table fixed header
C#
1 vote247 views1 answer
Ef rollback migration
C#
0 vote235 views1 answer
C# odp.net close session
C#
0 vote228 views1 answer
Blazor webassembly .net standard 2.1
C#
0 vote234 views1 answer
Mvc c# return renderPartial
C#
2 votes215 views1 answer
How to clone something unity
C#
0 vote266 views1 answer
C# check something is string
C#
0 vote239 views1 answer
Convert integers to written numbers C#
C#
0 vote232 views1 answer
Unity run all interfaces
C#
1 vote175 views1 answer
How to go from one form to another in c# windows application
C#