技术问答python鎬庝箞鍏抽棴excel鏂囦欢 - 扬州沐宇科技

浣跨敤python鍏抽棴excel鏂囦欢鐨勬柟娉曪細1.鏂板缓python椤圭洰锛?.瀵煎叆xlwt鍖咃紱3.浣跨敤xlwt.Workbook()鏂规硶鎵撳紑excel鏂囦欢锛?.浣跨敤add_sheet()鏂规硶澧炲姞sheet琛ㄦ牸锛?.浣跨敤write()鏂规硶娣诲姞鏁版嵁锛?.浣跨敤save()鍑芥暟鍏抽棴鏂囦欢锛?/p>

python鎬庝箞鍏抽棴excel鏂囦欢

鍏蜂綋姝ラ濡備笅锛?/p>

1.棣栧厛锛屾墦寮€python锛屽苟鏂板缓涓€涓猵ython椤圭洰锛?/p>

2.python椤圭洰鍒涘缓濂藉悗锛屽湪椤圭洰涓娇鐢╥mport鏂规硶瀵煎叆xlwt鍖咃紱

import xlwt

3.xlwt鍖呭鍏ュ悗锛屼娇鐢▁lwt.Workbook()鏂规硶鎵撳紑涓€涓猠xcel鏂囦欢锛屽苟璁剧疆鏂囦欢缂栫爜锛?/p>

workbook = xlwt.Workbook("D:\test.xls")

workbook = xlwt.Workbook(encoding='utf-8')

4.鏂囦欢缂栫爜璁剧疆濂藉悗锛屼娇鐢╝dd_sheet()鏂规硶鍦ㄦ枃浠朵腑澧炲姞涓€涓猻heet琛ㄦ牸锛?/p>

worksheet = workbook.add_sheet('My Worksheet')

5.sheet琛ㄦ牸澧炲姞鍚庯紝浣跨敤write()鏂规硶鍚戣〃鏍兼坊鍔犳暟鎹紱

worksheet.write(0, 0, '鍐呭')

6.鏈€鍚庯紝鏁版嵁娣诲姞鍚庯紝浣跨敤save()鍑芥暟鍗冲彲鍏抽棴excel鏂囦欢锛?/p>

workbook.save("D:\test.xls")