Python OPENPYXL Notes

Import warnings

Warnings.filterwarnings ("Ignore") # if there is no line code, a warning prompt appears: userwarning:discarded range with reserved name The reason Warnings.warn ("discarded range with reserved name") is that some other settings in Excel are ignored, there is no effect on our normal values in Excel, we can ignore

WB = Openpyxl.load_workbook (file_name, read_only=true) #打开文件

Wb.get_sheet_names () #获取所有的sheet_name

WS = Wb.get_sheet_by_name (sheet_name) #获取sheet对象

title = Ws.title #sheet名
rows = Ws.get_highest_row () #行数
cols = Ws.get_highest_column () #列数

Ws.cell (Row=1, column=3). Value #获取cell的值, if the cell value is empty, Ws.cell (Row=1, column=3) is None

Python OPENPYXL Notes