Csharp

Search

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);

Comment

PREVIOUS	NEXT

Code Example
Csharp :: dispathcer in wpf stack overflow
Csharp :: erlang start net kernel
Csharp :: bash clean-up code
Csharp :: .net core executenonqueryasync transaction
Csharp :: Dictionary of array in C#
Csharp :: open and close autocad api
Csharp :: .net 6 minimal api authorization net 6
Csharp :: asp.net stop page jumping to top on click
Csharp :: c# list to string replace last comma with and
Csharp :: how to make a 2d character move in unity 2020
Csharp :: credit card validation in c#
Csharp :: how can find github issue closed date
Csharp :: use Multiple forms in one Csharp panel in one Windows Form panel
Csharp :: shutdownHook c#
Csharp :: asp.net core user.identity.name is null
Csharp :: c# (sharp) varibles
Csharp :: c# Windows Forms screenshot
Csharp :: unity manager.instance
Csharp :: dotcms contentidentifier
Csharp :: c# extend array
Csharp :: c# instantiation
Csharp :: populate toolstripitems to combobox
Csharp :: new guid c# always returns 0
Csharp :: lexicographically sorted
Csharp :: if equal statement c#
Csharp :: stateteach.net
Csharp :: isdaylightsavingtime in c#
Csharp :: assign a list to another in c# without a loop
Csharp :: c# compare char arrays
Csharp :: add integer to string c#

Search

CSHARP

c# excel fix first row

ADD CONTENT