python读写xls

import xlrd

if __name__ == '__main__':
    # 打开一个workbook
    workbook = xlrd.open_workbook('C:\\Users\\liyang\\Desktop\\out.xls')
    # 抓取所有sheet页的名称
    worksheets = workbook.sheet_names()
    print('worksheets is %s' % worksheets)
    RECORDS7 = workbook.sheet_by_name("RECORDS7")
    # 遍历RECORDS7中所有行row
    num_rows = RECORDS7.nrows
    for curr_row in range(num_rows):
         row = RECORDS7.row_values(curr_row)
         print('row%s is %s' % (curr_row, row))
    #遍历RECORDS7中所有列col
    num_cols = RECORDS7.ncols
    for curr_col in range(num_cols):
        col = RECORDS7.col_values(curr_col)
        print('col%s is %s' % (curr_col, col))
    #遍历RECORDS7中所有单元格cell
    for rown in range(num_rows):
         for coln in range(num_cols):
             cell = RECORDS7.cell_value(rown, coln)
             print(cell , end=",")
         print()

import xlwt

# 创建workbook和sheet对象
workbook = xlwt.Workbook()
sheet1 = workbook.add_sheet('sheet1', cell_overwrite_ok=True)
sheet2 = workbook.add_sheet('sheet2', cell_overwrite_ok=True)
# 向sheet页中写入数据
sheet1.write(0, 0, '00')
sheet1.write(0, 1, '01')
sheet1.write(1, 0, '00')
sheet1.write(1, 1, '01')
sheet2.write(2, 2, '22')
sheet2.write(3, 2, '32')
# 保存该excel文件,有同名文件时直接覆盖
workbook.save('C:\\Users\\liyang\\Desktop\\out2.xls')