How to select a value in filter dropdown in excel

1 次查看（过去 30 天）
ashutosh
ashutosh 2014-12-5
回答： C.J. Harris 2014-12-5
Hello,
I have three questions.
  • I need to know if there's a way to programmatically select a value in filter dropdown in an Excel sheet.
  • Having selected this value, i need to hit a pushButton (again in the sheet itself).
  • Finally, what can be the approach to expand a pivot table in the sheet.
This sheet has text data.
Your help is highly appreciated for all/any of the above questions.
Best Regards, Ashutosh

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

回答（1 个）

C.J. Harris
C.J. Harris 2014-12-5
You might find it a lot easier to just write this specific functionality as an Excel macro, and then invoking the macro from MATLAB.
This can be done like in the example below:
Excel=actxserver('Excel.Application');
OutFileExcel = [pwd, '\Document.xls'];
eW = Excel.Workbooks;
eF = eW.Open(OutFileExcel);
invoke(Excel,'Run','Document.xls!My_Macro');
eF.Save;
invoke(Excel, 'Quit');

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by