Python基礎之excel

標籤：sheet   for   iter   ice   取資料   orm   寫入   write   .com   

python讀取excel主要是xlrd,python寫入和建立excel檔案可以用xlwt、XlsxWriter，xlwt支援office2013,XlsxWriter支援office2013及以上檔案。

建立和讀取excel代碼testXlrd.py：

#coding=utf-8import xlrdimport xlwt#通過xlrd讀取資料def readExcel():    filePath="d:\\a.xlsx"    data = xlrd.open_workbook(filePath)    table0 = data.sheets()[0]    nrows = table0.nrows    for i in range(nrows):        if i == 0: # 跳過第一行            continue        print(table0.row_values(i)[:5]) # 取前5列#通過xlwt寫入資料def writeExcel():    workbook = xlwt.Workbook() #注意Workbook的開頭W要大寫    sheet1 = workbook.add_sheet(‘sheet1‘)    #向sheet頁中寫入資料    sheet1.write(0,0,‘使用者名稱‘)    sheet1.write(0,1,‘郵箱‘)    sheet1.write(1,0,‘tom‘)    sheet1.write(1,1,‘[email protected]‘)    workbook.save(‘d:\\b.xls‘)    print(‘建立excel檔案完成！‘)

調用代碼：

Python 3.6.1 (v3.6.1:69c0db5, Mar 21 2017, 17:54:52) [MSC v.1900 32 bit (Intel)] on win32Type "copyright", "credits" or "license()" for more information.>>> from testXlrd import *>>> writeExcel()建立excel檔案完成！>>> readExcel()[1.0, ‘joyet1‘][2.0, ‘joyet2‘][3.0, ‘joyet3‘][4.0, ‘joyet4‘][5.0, ‘joyet5‘][6.0, ‘joyet6‘][7.0, ‘joyet7‘][8.0, ‘joyet8‘][9.0, ‘joyet9‘]>>> 

 

Python基礎之excel