none
Excel filtering with c# RRS feed

  • Question

  • Hy,
    i'm pretty new in programing, and need help.SO, need to creat a filter for 22 rows and the filter includes: x,(nothing) and all.
    Example:

         A  B  C    D......
    1   X      X       
    2   X  X        X    
    3   X                
    4  X      X      X   


    • Edited by Dawys22 Wednesday, August 1, 2018 9:37 AM
    Wednesday, August 1, 2018 8:04 AM

Answers

  • Hello Dawys22,

    How would you want to filter the data? If you just want to go to filter mode, you could try to use below code. If not, please detail your need.

    oSheet.Range["A2"].Select();
                oApp.Selection.AutoFilter();

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by Dawys22 Thursday, August 2, 2018 6:14 AM
    Thursday, August 2, 2018 1:32 AM

All replies

  • Hy,
    i'm pretty new in programing, and need help.SO, need to creat a filter for 22 rows and the filter includes: x,(nothing) and all.
    Example:

         A  B  C    D......
    1   X      X       
    2   X  X        X    
    3   X                
    4  X      X      X   
    Wednesday, August 1, 2018 10:04 AM
  • Hello Dawys22,

    How would you want to filter the data? If you just want to go to filter mode, you could try to use below code. If not, please detail your need.

    oSheet.Range["A2"].Select();
                oApp.Selection.AutoFilter();

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by Dawys22 Thursday, August 2, 2018 6:14 AM
    Thursday, August 2, 2018 1:32 AM