扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

openpyxl鎬庝箞鎵归噺鍐欏叆鏁版嵁

扬州沐宇科技
2024-02-04 10:02:41
openpyxl

浣跨敤openpyxl鍙互寰堟柟渚垮湴鎵归噺鍐欏叆鏁版嵁銆備笅闈㈡槸涓€涓ず渚嬩唬鐮侊細

from openpyxl import Workbook

# 鍒涘缓涓€涓柊鐨勫伐浣滅翱
wb = Workbook()

# 鑾峰彇绗竴涓伐浣滆〃
ws = wb.active

# 瀹氫箟瑕佸啓鍏ョ殑鏁版嵁
data = [
    ['濮撳悕', '骞撮緞', '鎬у埆'],
    ['寮犱笁', 20, '鐢?#x27;],
    ['鏉庡洓', 21, '濂?#x27;],
    ['鐜嬩簲', 22, '鐢?#x27;],
]

# 鎵归噺鍐欏叆鏁版嵁
for row in data:
    ws.append(row)

# 淇濆瓨宸ヤ綔绨?/span>
wb.save('example.xlsx')

杩欐浠g爜鍒涘缓浜嗕竴涓柊鐨勫伐浣滅翱锛屽苟鍦ㄧ涓€涓伐浣滆〃涓壒閲忓啓鍏ヤ簡鏁版嵁銆傛暟鎹€氳繃涓€涓簩缁村垪琛ㄤ紶閫掞紝姣忎釜瀛愬垪琛ㄨ〃绀轰竴琛屾暟鎹€傚湪寰幆涓紝浣跨敤ws.append()鏂规硶灏嗘瘡涓€琛屾暟鎹啓鍏ュ伐浣滆〃銆傛渶鍚庨€氳繃wb.save()鏂规硶淇濆瓨宸ヤ綔绨垮埌鏂囦欢涓€?/p>

扫码添加客服微信