滚动页面,把所有TextView上的语言文本提取并写入Excel中。

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")