Disable Autofiltermode in excel sheet using matlab script

6 次查看（过去 30 天）
Logson maddy
Logson maddy 2020-4-10
回答： Jatin 2024-9-6
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;

请先登录，再回答此问题。

回答（1 个）

Jatin
Jatin 2024-9-6
Hi @Logson maddy,
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!

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by