随笔分类 - openpyxl
摘要:openpyxl # Get Table by name or range from openpyxl import * wb = load_workbook(path) ws = wb.get_active_sheet() # 读取A1:D10 A1_D10 = ws.tables["A1:D10
阅读全文
摘要:####openpyxl from openpyxl import * wb = load_workbook(path) # 方式1 wb._sheets[0] # 方式2 wb.get_active_sheet() # 方式3 wb.get_sheet_by_name('Sheet1') # 方式
阅读全文