python 读写Excel的数据

# coding=utf-8

import xlwt
import xlrd
from xlutils.copy import copy
# import xlutils.copy


class ExcelDataClass:
    excelDir = r'..\resourice_Data\自动化测试表.xls'
    excelDir1 = r'..\resourice_Data\自动化测试表1.xls'

    # 创建一个空的Excel表格
    def emptyTable(self):
        workBook = xlwt.Workbook(encoding='utf-8')
        workSheet = workBook.add_sheet('sheet_jiangnan')
        workBook.save('自动化测试空表.xls')
        print('Run')

    # 写入一个已存在的Excel表格
    def writeExcel(self,rows,endrows,test_Data1,test_Data2):

        # excelDir = r'..\resourice_Data\自动化测试表.xls'
        # excelDir1 = r'..\resourice_Data\自动化测试表1.xls'
        # 打开excel
        workBook = xlrd.open_workbook(self.excelDir)


        new_workBook = copy(workBook)
        new_workSheet = new_workBook.get_sheet('sheet_jiangnan')


        for i in range(rows-1, endrows):
            print(i)
            new_workSheet.write(i, 8, test_Data1)
            new_workSheet.write(i, 9, test_Data2)

            new_workBook.save(self.excelDir1)

    # 获取excel表格中的数据信息
    def getExcel(self,Row_star,endrows):

        workBook = xlrd.open_workbook(self.excelDir)
        # workSheet = workBook.get_sheet('sheet_jiangnan')
        workSheet = workBook.sheet_by_name('sheet_jiangnan')

        resDataList = []
        for i in range(Row_star-1,endrows):
            cellData1 = workSheet.cell_value(i, 6)
            cellData2 = workSheet.cell_value(i, 7)

            resDataList.append((cellData1,cellData2))

        return resDataList





if __name__ == '__main__':
    ExcelDataClass().writeExcel(5,7,'今天是个好日子','19880209')
    resList = ExcelDataClass().getExcel(2,4)
    print(resList)