Disable Autofiltermode in excel sheet using matlab script
2 views (last 30 days)
Show older comments
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;
0 Comments
Answers (1)
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!
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!