from openpyxl import Workbook
# 初始化Appium连接
driver = webdriver.Remote('http://localhost:4723/wd/hub', {
'platformName': 'Android',
'deviceName': 'emulator-5554',
'appPackage': 'com.example.setupwizard',
'appActivity': 'com.example.setupwizard.LanguageActivity',
'automationName': 'UiAutomator2'
})
# 滚动并获取所有语言元素(假设为TextView)
language_elements = set()
while True:
visible_texts = [el.text for el in driver.find_elements_by_class_name('android.widget.TextView')]
added = language_elements.union(visible_texts)
if added == language_elements:
break
language_elements = added
driver.swipe(500, 1600, 500, 400, 800) # 向上滑动
# 排序(保持原顺序)
language_list = list(language_elements)
# 写入Excel
wb = Workbook()
ws = wb.active
ws.title = "Languages"
for i, lang in enumerate(language_list, start=1):
ws.cell(row=i, column=1, value=lang)
wb.save("language_list.xlsx")