<p>这可能是一个简单的任务,但就我的一生而言,我找不到解决办法。我有一个有表格的excel文档。此表中的所有列都应用了自动筛选。我所要做的就是能够选择自动筛选(第9列)中的所有条目并将其存储在一个数组中。我在用Win32Com。在</p>
<pre><code>import win32com.client as win32
working_dir = 'C:\\invoice\\'
save_dir = 'C:\\test\\'
xl = win32.gencache.EnsureDispatch("Excel.Application")
xl.Visible = True
template_wb = xl.Workbooks.Open(working_dir + 'Settlement report V6-EMPLATE.xlsm')
#Worksheets
orgdata_ws = template_wb.Sheets('Organization Data')
masterdata_ws = template_wb.Sheets('Master Data')
#I want to access the autofilter in column 9 and simply get the contents in the autofilter list and put them in the array
filtercontents = []
thefilter = orgdata_ws.Columns(9).Autofilter
for i in thefilter:
filtercontents.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>(i) ?????????
</code></pre>