python操作excel

標籤：python   div   rom   工作   /usr   一個   val   int   example   

@(python之路)[python操作excel]
python操作excel
-----
[TOC]

寫excel

#!/usr/bin/env python# -*- coding:utf-8 -*-import xlwtwb = xlwt.Workbook()sheet = wb.add_sheet('sheet1')for row in range(10):    for col in range(5):        sheet.write(row, col, '第{0}行第{1}列'.format(row, col))wb.save('xxx.xls')# 更多樣本：https://github.com/python-excel/xlwt/tree/master/examples

讀取excel

#!/usr/bin/env python# -*- coding:utf-8 -*-import xlrdfrom xlrd.book import Bookfrom xlrd.sheet import Sheetfrom xlrd.sheet import Cellworkbook = xlrd.open_workbook('基礎課程大綱.xlsx')sheet_names = workbook.sheet_names()# sheet = workbook.sheet_by_name('工作表1')sheet = workbook.sheet_by_index(1)# 迴圈Excel檔案的所有行for row in sheet.get_rows():    # 迴圈一行的所有列    for col in row:        # 擷取一個儲存格中的值        print(col.value)

python操作excel