excel_tool/run_tests.py

import subprocess

def run_translate_new_col():
    print("Running translate_new_col.py...")
    subprocess.run(["python", "translate_new_col.py"])
    print("translate_new_col.py completed.\n")

def run_brand_add_url_link():
    print("Running brand_add_url_link.py...")
    subprocess.run(["python", "brand_add_url_link.py"])
    print("brand_add_url_link.py completed.\n")

def main():
    print("Starting test sequence...\n")
    
    # 第一步：运行翻译脚本
    run_translate_new_col()
    
    # 第二步：运行品牌和ASIN链接脚本
    run_brand_add_url_link()
    
    print("All tests completed successfully!")

if __name__ == "__main__":
    main()