Python-開啟檔案-excel

Python
開啟檔案
excel

安裝:
linux、mac :pip3 install openpyxl、pip3 install xlwt、pip3 install xlrd
windows    :之後補上

程式碼說明

2007年版後
寫入

from openpyxl import Workbook,load_workbook

wb = Workbook()

ws = wb.active



ws1 = wb.create_sheet('Mysheet')

ws2 = wb.create_sheet('Mysheet', 0)

ws1.title = 'New Title'




print(wb.sheetnames)




ws['A4'] = 4

ws.cell(row=4, column=2, value=10)




wb.save('demo.xlsx') 




讀取

wb_load = load_workbook('demo.xlsx') 

sheet_ranges = wb_load['Sheet']

print(sheet_ranges['A4'].value)

2007年版前
寫入

import xlwt

from datetime import datetime




style0 = xlwt.easyxf('font: name Times New Roman, \

color-index red, bold on',num_format_str='#,##0.00')




style1 = xlwt.easyxf(num_format_str='D-MMM-YY')




wb = xlwt.Workbook()

ws = wb.add_sheet('A Test Sheet')







ws.write(0, 0, 124, style0)

ws.write(1, 0, datetime.now(), style1)

ws.write(2, 0, 1)

ws.write(2, 1, 1)

ws.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('demo.xls')


讀取

import xlrd

book = xlrd.open_workbook("demo.xls")

print("The number of worksheets is {0}".format(book.nsheets))

print("Worksheet name(s): {0}".format(book.sheet_names()))

sh = book.sheet_by_index(0)

print("{0} {1} {2}".format(sh.name, sh.nrows, sh.ncols))

print("Cell A1 is {0}".format(sh.cell_value(rowx=2, colx=1)))

for rx in range(sh.nrows):

    print(sh.row(rx))



程式碼說明

openpyxl同時能夠讀寫
xlwt只能夠寫
xlrd只能夠讀

2007年後板本

匯入必要模組
建立workbook()
啟動worksheet
建立sheet，一共三個，中階還有改名字
給ws['A4']值
給ws row=4 column=2值
存檔
讀檔
指定ws特定sheet
印出特定位置資料


2007年前板本

匯入必要模組
定義sytle
建立workbook()
啟動worksheet
建立sheet，一共三個，中階還有改名字
給ws特定位置值
存檔

匯入必要模組
讀檔
印出特定資料表各種屬性