# 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()
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)