Clear Filters
Clear Filters

Disable Autofiltermode in excel sheet using matlab script

2 views (last 30 days)
Hi Im trying to disable the filter applied in all the columns in excel sheet using below code but its not working. please help with right command to disalbe autofilter
[filename,path1]=uigetfile('*.xlsx','Select file');
filename1=strcat('\',filename);
filename=strcat(pwd,filename1);
exl = actxserver('excel.application');
exlWkbk = exl.Workbooks;
exlFile = exlWkbk.Open(filename);
exlFile.Activate
SignalDBsht=exlFile.Sheets.Item('Signal');
Activesheet.autofiltermode='False';
exlFile.Save();
exlFile.Close();
exl.Quit;
exl.delete;

Answers (1)

Jatin
Jatin on 6 Sep 2024
Your script to disable the "autofiltermode" is almost correct. The issue lies in assigning 'False' as a string instead of using a Boolean value.
Here's the revised code that should achieve the desired result:
% Activate the specific sheet
SignalDBsht = exlFile.Sheets.Item('Signal');
SignalDBsht.Activate;
% Check if AutoFilter is on and turn it off
if SignalDBsht.AutoFilterMode
SignalDBsht.AutoFilterMode = false;
end
Hope this helps!

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!