<!-- markdown css tag --><div class="pinggu_markdown">
<div class="pinggu_markdown__html"><p>import xlwings as xw<br>
from random import randint</p>
<p>def get_sel_excel(path):<br>
sel = []<br>
app = xw.App(visible=False, add_book=False)<br>
wb = app.books.open(path)<br>
sht = wb.sheets(1)<br>
for i in range(1,randint(1,31)):<br>
sel.append(sht.cells(i,1).value)<br>
wb.close()<br>
app.quit()<br>
return sel</p>
<p>print(get_sel_excel(r’D:\1\test.xlsx’))</p>
</div>
</div>

不知道为什么不能用markdown编辑思路就是直接做一个空列表用来装所有的变量，然后输出就好了
很简单，几行代码就搞定

**kwargs

deviceid=936a6b62e2e666e6fd5f5fb5a86ec59; Hm_lvt_4b46d92b8c2be1622e347873de8ada00=1668992977; Hm_lpvt_4b46d92b8c2be1622e347873de8ada00=1668992977; Hm_lvt_c420cc498e4250baa6114afe2947045e=1668992977; Hm_lpvt_c420cc498e4250baa6114afe2947045e=1668992977; Qs_lvt_404253=1668992983; Qs_pv_404253=1044008591704842100%2C3100009624321203000