PythonがExcelを操作する方法パッケージ

PythonがExcelを操作する方法パッケージ

class Excel:
    def __init__(self,filename,sheetname):
        '''

        :type filename: str -- excel     
        :param sheetname: str --      excel  
        '''
        self.filename = filename
        try:
            self.wb = openpyxl.load_workbook(self.filename)     #      ，           
        except:
            self.wb=openpyxl.Workbook()
            self.wb.save(filename)
        try:
            self.sheet = self.wb[sheetname]                #     ，          
        except:
            self.wb.create_sheet(title=sheetname)
            self.sheet=self.wb[sheetname]
            self.wb.save(filename)

    #  excel       
    def MaxRow(self):
        maxrow = self.sheet.max_row
        return maxrow

    #  excel        
    def MaxCol(self):
        maxcol=self.sheet.max_column
        return maxcol

    #         
    def read(self,row,col):
        info=self.sheet.cell(row=row, column=col).value
        try:
            info=str(info)
        except:
            pass
        return info

    #       
    def readline(self,row):
        maxcol=self.MaxCol()
        info=[]
        for i in range(1,maxcol+1):
            content=self.sheet.cell(row=row,column=i).value
            try:
                content=str(content)
            except:
                pass
            info.append(content)
        return info

    #      
    def readall(self):
        maxrow=self.MaxRow()
        info=[]
        for i in range(1,maxrow+1):
            content=self.readline(i)
            info.append(content)
        return info

    def readcol(self,column):
        maxrow = self.MaxRow()
        info=[]
        for i in range(1, maxrow + 1):
            content=self.sheet.cell(row=i, column=column).value
            try:
                content = str(content)
            except:
                pass
            info.append(content)
        return info

    #          
    def wt(self, rownum, colnum, data):
        self.sheet.cell(row=rownum, column=colnum).value = data
        self.wb.save(self.filename)


    #         ，data   
    def wtline(self,row,data):
        num=len(data)
        for i in range(0,num):
            self.sheet.cell(row=row, column=i+1).value=data[i]
        self.wb.save(self.filename)

(転載出典明記)