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>