Python-pandas读写Excel

# MyExcelTools.py
# from MyExcelTools.py import *
import numpy as np
import pandas as pd


# 读Excel文件，返回2维list
def readExcel(path, sheet):
    data = pd.read_excel(path, sheet_name=sheet, header=None)
    return data.values.tolist()


# 写Excel文件，传入2维list
def writeExcel(data, savePath, sheet):
    data = np.array(data)
    writer = pd.ExcelWriter(savePath)
    pd.DataFrame(data).to_excel(writer, sheet_name=sheet, index=False, header=None)
    writer.save()