python操作excel

#-*- coding:utf-8 -*-
import xlrd
from openpyxl import Workbook


class Excel:
    def __init__(self):
        self.wb = Workbook()
        self.ws = self.wb.active
        self.sheet = []
        self.workbook = xlrd.open_workbook('excel path')

    def date(self):
        sheetname = self.sheet(self.workbook.sheets())
        #获取一个工作薄的所有sheet的名字        
        for i in sheetname:
            #根据sheet名字获取一个表的数据            sheet = self.workbook.sheet_by_name(i)
            for s in sheet.nrows:
                #获取一行数据                data  = sheet.row_values(s)
                self.ws.append(data)
        self.wb.save('%s.xlsx' % i)



e = Excel()
e.date()