Breaking News: Grepper is joining You.com. Read the official announcement!

c# excel fix first row

Open Ox answered on November 10, 2021 Popularity 1/10 Helpfulness 1/10

answer c# excel fix first row

c# excel fix first row

Comment

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

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# excel row

Link to this answer
Share Copy Link