讀取excel

import xlrd

file = "../data/聊天記錄1.xlsx"

def read_excel():
    wb = xlrd.open_workbook(filename=file)
    sheet1 = wb.sheet_by_index(0)
    nrows = sheet1.nrows # 行數(shù)
    ncols = sheet1.ncols #列數(shù)
    print(nrows)
    print(ncols)
    # rows = sheet1.row_values(2) #獲取行內(nèi)容
    # cols = sheet1.col_values(3)  # 獲取列內(nèi)容
    # print(rows)
    # print(cols)
    print(sheet1.cell(1, 0).value)#獲取表格里的內(nèi)容

if __name__ == "__main__":
    read_excel()

寫(xiě)excel

from tempfile import TemporaryFile
from xlwt import Workbook

book = Workbook()
sheet1 = book.add_sheet('Sheet 1')

# sheet1.write(0,0,'A1')
# sheet1.write(0,1,'B1')


data = {
    "1": ["張三", 150, 120, 100],
    "2": ["李四", 90, 99, 95],
    "3": ["王五", 60, 66, 68]
}
# 字典數(shù)據(jù)

ldata = []
num = [a for a in data]
# for循環(huán)指定取出key值存入num中
num.sort()
# 字典數(shù)據(jù)取出后無(wú)需，需要先排序

for x in num:
    # for循環(huán)將data字典中的鍵和值分批的保存在ldata中
    t = [int(x)]
    for a in data[x]:
        t.append(a)
    ldata.append(t)

#ldata的形式就是[[1,張三,150,120,100],[2,李四,90,99,95]...]
for i, p in enumerate(ldata):
    # 將數(shù)據(jù)寫(xiě)入文件,i是enumerate()函數(shù)返回的序號(hào)數(shù)
    for j, q in enumerate(p):
        sheet1.write(i, j, q)

sheet1.flush_row_data()
book.save('simple2.xls')
book.save(TemporaryFile())

最后寫(xiě)入的格式如下圖：

image.png