教你使用Python批量读写excel文件

pip install xlrd

import xlrd

# 给出excel文件绝对路径
loc = ("path of file") 
# 打开工作表
wb = xlrd.open_workbook(loc) 
# 这里读取的是第一个sheet
sheet = wb.sheet_by_index(0)

>>> print(sheet.cell_value(0, 0) )
'NAME'

>>> print(sheet.nrows) # 行数
4
>>> print(sheet.ncols) # 列数
3

>>> for i in range(sheet.ncols):         
        print(sheet.cell_value(0, i)) 
NAME
SEMESTER
ROLL NO

>>> for i in range(sheet.nrows): 
        print(sheet.cell_value(i, 0)) 
NAME
ALEX
CLAY
JUSTIN

>>> print(sheet.row_values(1)) 
['ALEX', 4.0, 2011272.0]

pip install xlwt

import xlwt 
from xlwt import Workbook

# 创建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')

# 先导入xlrt库
import xlwt 
# 创建workbook
workbook = xlwt.Workbook()  
# 创建sheet 
sheet = workbook.add_sheet("Sheet Name") 
# 给单元格内容添加格式：加粗、标红
style = xlwt.easyxf('font: bold 1,color: red') 
# 在单元格中写入数据
sheet.write(0, 0, 'SAMPLE', style) 
# 保存excel
workbook.save("sample.xls")