客服如何批量查询物流单号的物流情况？今天拿邮政距离

# 物流查询——中国邮政包裹
import urllib.request
import json
from openpyxl import load_workbook
import time

def query_post_logistics(tracking_number):
    """查询中国邮政包裹物流信息"""
    url = f"http://www.xxxxxx.com/query?type=youzhengguonei&postid={tracking_number}"
    headers = {"User-Agent": "Mozilla/5.0"}

    try:
        req = urllib.request.Request(url, headers=headers)
        with urllib.request.urlopen(req, timeout=10) as response:
            data = json.loads(response.read().decode('utf-8'))

        if data.get('status') == '200' and 'data' in data:
            # 打印原始数据（调试用）
            print(f"✅ 查询成功：{tracking_number}")
            detail_list = [
                f"{item['time']} - {item['context']}"
                for item in data['data']
            ]
            return "有", "\n".join(detail_list)
        else:
            print(f"❌ 查询失败：{tracking_number} -> {data.get('message', '无信息')}")
            return "无", f"查询失败：{data.get('message', '无信息')}"
    except Exception as e:
        print(f"⚠️ 查询异常：{tracking_number} -> {e}")
        return "无", f"查询异常：{e}"

def update_excel(file_path):
    """逐条写入Excel，每查一条即保存"""
    wb = load_workbook(file_path)
    ws = wb.active  # 默认第一个sheet

    for row in ws.iter_rows(min_row=2):  # 从第二行开始，跳过表头
        tracking_number = str(row[0].value).strip() if row[0].value else ""
        if not tracking_number:
            continue

        print(f"\n🚚 正在查询：{tracking_number}")
        status, detail = query_post_logistics(tracking_number)

        row[1].value = status  # 第二列：有/无
        row[2].value = detail  # 第三列：详细物流信息

        # 每查一个就保存，防止中途出错丢失
        wb.save(file_path)
        print(f"💾 已保存：{tracking_number}")

        # 控制请求频率，防止被封
        time.sleep(1.5)

    print("\n✅ 全部查询完成，结果已写入 Excel。")

# 示例：修改为你的Excel文件路径
update_excel("邮政更新10月(2).xlsx")