读
- import xlrd
- from xlrd.book import Book
- from xlrd.sheet import Sheet
- from xlrd.sheet import Cell
- workbook = xlrd.open_workbook('基础课程大纲. xlsx')
- sheet_names = workbook.sheet_names()
- # sheet = workbook.sheet_by_name('工作表 1')
- sheet = workbook.sheet_by_index(1)
- # 循环 Excel 文件的所有行
- for row in sheet.get_rows():
- # 循环一行的所有列
- for col in row:
- # 获取一个单元格中的值
- print(col.value)
写
- import xlwt
- wb = xlwt.Workbook()
- sheet = wb.add_sheet('sheet1')
- for row in range(10):
- for col in range(5):
- sheet.write(row, col, '第 {0} 行第 {1} 列'.format(row, col))
- wb.save('xxx.xls')
- # 更多示例: https://github.com/python-excel/xlwt/tree/master/examples
来源: http://www.bubuko.com/infodetail-2630986.html