1.工作簿
2.工作表
3.单元格
读取excel文件数据:
def read_excel(path): #1.获取工作簿 wk = openpyxl.load_workbook(path) # 2.获取工作表 sheets = wk.sheetnames for sheet in sheets: my_sheet = wk[sheet] result = list() # 3.获取单元格 for row in range(2,my_sheet.max_row+1): result_row = list() for column in range(1,my_sheet.max_column+1): result_row.append(my_sheet.cell(row,column).value) result.append(result_row) print(result)
写入表格数据:
def create_excel(): #1.创建工作簿 wk = openpyxl.Workbook() #2.获取当前工作表 my_sheet = wk.active #3.写入数据 my_sheet.cell(1,1).value = "name" my_sheet.cell(1,2).value = "age" #4.保存表格 wk.save("user.xlsx")
写入多条数据:
def add_manyuData(path): #1.打开共工作簿 wk = openpyxl.load_workbook(path) #2.创建工作表 my_sheet = wk.create_sheet() #3.一次性写入数据 data = [1,2,3,4,5,6] my_sheet.append(data) #4.保存工作簿 wk.save(path)