openpyxl版本: 2.5.0, pandas版本: 0.22
# -*- coding:utf-8 -*-
from pandas import DataFrame
from openpyxl import load_workbook
from openpyxl.utils.dataframe import dataframe_to_rows
from Tools.tools import decoLOG
from Tools.Log import Log
'''
功能: Excel类
作者:
作成时间:
更新内容:
更新时间:
'''
class Excel(object):
def __init__(self, filename=""):
# excel file
self.fileName = filename
self.workbook = None
# open excel
def openFile(self, filename=""):
if filename == "" and self.fileName == "":
Log().logger.error("Open Excel Error![Filename is nothing]")
return None
else:
try:
self.fileName = (filename if filename!=