||
import os
import xlrd
import shutil
import xlwt
import numpy as np
from xlrd import xldate_as_tuple
def position_list(c1,l1):
pl=[]
for i,j in enumerate(l1):
if c1==j:
pl.append(i)
return(pl)
lujing= "P:....
province="湖北省"
wenjian="(2)物候资料"
#-------------------------------------------
sht = xlrd.open_workbook(lujing+province+"/(5)物候普通/"+wenjian+".xlsx").sheet_by_index(0)
titles_col = sht.row_values(0)[:]#第一行的名字
titles_row = sht.col_values(0)[:]#第一列的名字
names = list(set(sht.col_values(1)[1:]))#地级市的名字
cities = sht.col_values(1)[:]
for nn in names:
PPP = lujing+province+"/"+nn+"/(5)物候普通/"
if not(os.path.exists(PPP)):
os.makedirs(PPP)#-----------创建文件夹-----
f = xlwt.Workbook()#-----------写入各地级市excel---
sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True)
pl = position_list(nn,cities)
#第一行
temp = sht.row_values(0)[:]
for j,k in enumerate(temp):
sheet1.write(0,j,k)
#其他行
idx = 0
for i in range(0,len(titles_row)):
if i in pl:
idx+=1
temp = sht.row_values(i)[:]
for j,k in enumerate(temp):
if j==5 or j==6:
sheet1.write(idx,j,str(xldate_as_tuple(k,0)[1])+'月'+str(xldate_as_tuple(k,0)[2])+"日")
else:
sheet1.write(idx,j,k)
f.save(PPP+wenjian+".xls")
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-9-27 13:19
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社