FPT Software is part of FPT Corporation (FPT – HoSE) – the global leading technology and IT services group headquartered in Vietnam with nearly US$1.2 billion in revenue and 28,000 employees. Qualified with CMMI Level 5 & ISO 27001:2013, ASPICE LEVEL 3, FPT Software delivers world-class services in Smart factory, Digital platform, RPA, AI, IoT, Enterprise Mobilization, Cloud, AR/VR, Embedded System, Managed service, Testing, Platform modernization, Business Applications, Application Service, BPO and more services globally from delivery centers across the United States, Japan, Europe, Australia, Vietnam and the Asia Pacific.

03d12680-8cf7-4189-a0ea-fd7e29d72ec9.jpg

f24f8d92-73b4-4e42-8933-8da2d245f0ab.jpg

RPA Innovation Department Manager

832bc228-7af7-4813-8248-5f5275808c7f.nupkg

This component uses VB.Net to open an Excel file then remove the filters.

  

There are many ways to do the same operation but VB.Net is more stable than using hotkey or Click activity to work with Excel application.

  

*   \`\`\`\`In argument:

1.  in\_FilePath (String): Excel file path
2.  in\_SheetName (String): Excel file name
3.  in\_Mode (String): there are 2 modes:

         - KeepAutoFilter: Remove all filter conditions but keep filter function on.

         - RemoveAutoFilter: Remove filter function

This component is used to remove the filters from an Excel file

FPT Software - Remove Auto Filter