excel应用

import xlrd
from xlutils.copy import copy

class ExcelTools():

    def __init__(self,data_file='../datas/datas.xlsx'):
        self.workbook=xlrd.open_workbook(data_file)
        self.copy_workbook=copy(self.workbook)

    def get_all_sheet_data(self,sheet_name): #单表的所有数据

        data_list=[]
        sheet=self.workbook.sheet_by_name(sheet_name) #根据表名读取
        for rowes in range(sheet.nrows):
            #取出每行数据加入列表
            row=sheet.row_values(rowes)
            data_list.append(row)
        return data_list

    def get_all_sheet_names(self,name=None): #所有表名
        names=self.workbook.sheet_names()
        if name!=None:
            indexed=names.index(name)
            print(indexed)
            return indexed

        return names

    def get_print_data(self,data): #打印所有数据
        rows=len(data)
        for i in range(rows):
            if i!=0:
                rowed=data[i]
                print(rowed)

    def get_nrows(self,sheet_name): #行数
        sheet=self.workbook.sheet_by_name(sheet_name)
        nrows=sheet.nrows
        return nrows

    def write_data_to_sheet(self,sheet_index,row,col,value):    #写入表
        sheet = self.copy_workbook.get_sheet(sheet_index)
        sheet.write(row,col,value)

    def save_workbook(self,report_name="../report/report.xlsx"):    #保存表
        self.copy_workbook.save(report_name)


if __name__ == '__main__':

    util=ExcelTools('../datas/datas.xlsx')
    names=util.get_all_sheet_names()
    data=util.get_all_sheet_data(names[0])
    util.get_print_data(data)
    util.get_nrows(names[0])