How to Freeze Top Row and Apply Filter in Excel Automation with C

Question

I have automated Excel document creation using C#. I'm attempting to apply a filter while also freezing the worksheet's top row. If you choose View > Freeze Panes > Freeze top row, followed by top row Data > Filter, this is the same as in Excel 2010. I have no idea how to use the filter, but I tried the following to freeze the top row, and it simply frozen the entire worksheet. I'm looking for a solution to my issue. I need additional assistance with the data filter issue; if you know of a solution, kindly let me know.

Answer 1

Try this:

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