python读写xls

import xlrdif __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')