当面对成百上千个excel文件,需要重复读写时,你会不会很头大呢? 与其花费好几天去做这些繁琐无意义的操作,不如学学python如何批量读写excel文件,几分钟就能搞定一整天的活! 使用xlrd库读取excel 01 pip install xlrd
# 给出excel文件绝对路径 loc = ('path of file') # 打开工作表 wb = xlrd.open_workbook(loc) # 这里读取的是第一个sheet sheet = wb.sheet_by_index(0)
>>> print(sheet.nrows) # 行数 4 >>> print(sheet.ncols) # 列数 3
>>> for i in range(sheet.nrows): print(sheet.cell_value(i, 0)) NAME ALEX CLAY JUSTIN
使用xlwt写入excel 02 pip install xlwt
# 创建workbook wb = Workbook() # 使用add_sheet函数创建新的sheet sheet1 = wb.add_sheet('Sheet 1') # 写入数据,参数分别为行、列、数据 sheet1.write(1, 0, 'ISBT DEHRADUN') sheet1.write(2, 0, 'SHASTRADHARA') sheet1.write(3, 0, 'CLEMEN TOWN') sheet1.write(4, 0, 'RAJPUR ROAD') sheet1.write(5, 0, 'CLOCK TOWER') sheet1.write(0, 1, 'ISBT DEHRADUN') sheet1.write(0, 2, 'SHASTRADHARA') sheet1.write(0, 3, 'CLEMEN TOWN') sheet1.write(0, 4, 'RAJPUR ROAD') sheet1.write(0, 5, 'CLOCK TOWER') # 保存到excel表格 wb.save('xlwt example.xls')
|
|