pip install xlwt
pip install xlrd
python
import xlwt
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('Sheet1')
worksheet.write(1, 1, 20)
worksheet.write(2, 1, 25)
workbook.save('example.xls')
python
import xlrd
workbook = xlrd.open_workbook('example.xls')
worksheet = workbook.sheet_by_index(0)
for row in range(worksheet.nrows):
for col in range(worksheet.ncols):
cell_value = worksheet.cell_value(row, col)