import pandas as pd
ff = 1
def readExcelvalue():
ff = 1
t1 = time.time()
for f in os.listdir("D://software/accuracy/southsudan37dailyreport/2022/202202/sum/"):
df = pd.read_excel("D://software/accuracy/southsudan37dailyreport/2022/202202/sum/" + f ,sheet_name='Summary', skiprows=27 , nrows=1, header=None)
print("读取指定某行某列(单元格)的数据:\n{0}".format(df))
df.to_excel("sheettest3.xlsx", startrow=ff , index=False, header=False)
ff=ff+1
print("提取完成......")
t2 = time.time()
print(t2 - t1)
readExcelvalue()
问题:Pandas 提取一个文件夹内的excel指定行列数据并写入一个新EXCEL文件,数据覆盖
于 2024-02-26 16:01:00 首次发布