import xlrd def read_xlrd(excelFile): data = xlrd.open_workbook(excelFile) table = data.sheet_by_index(0) for rowNum in range(table.nrows): rowVale = table.row_values(rowNum) for colNum in range(table.ncols): if rowNum > 0 and colNum == 0: print(int(rowVale[0])) else: print(rowVale[colNum]) print("---------------") # if判断是将 id 进行格式化 # print("未格式化Id的数据:") # print(table.cell(1, 0)) # 结果:number:1001.0 if __name__ == '__main__': excelFile = 'test.xlsx' read_xlrd(excelFile=excelFile)
python xlrd 处理 excel
最新推荐文章于 2024-02-23 20:22:12 发布