import xlrd,xlwt #打开excel文件并获取所有sheet workbook = xlrd.open_workbook(r'D:\1.xlsx') sheetlist=workbook.sheet_names() # print (sheetlist) coldata=[] for ele in sheetlist: sheet=workbook.sheet_by_name(ele) col=sheet.ncols row=sheet.nrows # print("打印"+ele) # for i in range(col): # print("第"+str(i)+"列") # print(sheet.col_values(i))