python读写各种文件

读写txt文件

写

    with open(txtFilePath,'w') as file:
        for str in results:
            file.write(str)
        for str in parallel_results:
            file.write(str)

读

    with open(file_path, 'r') as file:
        lines = file.readlines()  # 读取所有行并将其存储在一个列表中
        #统计所有失败用例的名称
        for line in lines:
        	print(line)

读写xls表格文件

参考链接

读

import xlrd   #引入库
    wb=xlrd.open_workbook(excel_path)
    sheet_num = wb.nsheets
    sheet_names=wb.sheet_names()
    sheet = wb.sheet_by_index(0)
    rows = sheet.nrows  # 获取sheet页的行数，一共有几行
    columns = sheet.ncols  # 获取sheet页的列数，一共有几列
    # 获取第一行的数据
    row_data = sheet.row_values(0)  # 返回给定的行数的单元格数据进行切片
    # 获取第二列的数据
    col_data = sheet.col_values(3)
    print(col_data)

写

import xlwt
book = xlwt.Workbook(encoding='utf-8', style_compression=0)
    col = ('用例类别','用例名称','失败原因')
    sheet = book.add_sheet('parallelschedule0失败用例统计', cell_overwrite_ok=True)
    for i in range(0, 3):
        sheet.write(0, i, col[i])
    row = 1
    for str in results:
        sheet.write(row,1,str)
        row += 1
    for str in parallel_results:
        sheet.write(row,1,str)
        row += 1
    book.save(excelFilePath)