pandas模块实现excel文件的批量读取与保存工具

操作excel的工具类

需要引入logger模块

import os.path
import time

import pandas as pd

from util import logger

LOGGER = logger.MyLogger("excelUtils").getLogger()


class ExcelReader:
    """
    读取excel工具
    """

    def __init__(self, path, file_suffix=".xls", sort_by=None):
        self.path = path
        self.file_suffix = file_suffix
        self.sort_by = sort_by

    def setPath(self, path, file_suffix=".xls", sort_by=None):
        self.__init__(path, file_suffix=file_suffix, sort_by=sort_by)

    def getData(self, sheet_name=0, skiprows=0, skipfooter=0, to_records=