生成索书号、馆藏地、价格等总表
import xlrd
import xlsxwriter
import time
import datetime
import copy
def wt_xls(n_list):
n=n_list.split(",")
return n
def poplist(li):
new_list=li.copy()
a=""
for _ in range(6):
del new_list[0]
for _ in range(1,8):
del new_list[-1]
for i in range(len(new_list)):
a+=new_list[i]+" "
return a
def write(E):
R=["B","C","A","D","E"]
I=[-6,-5,-4,-1]
workbook = xlsxwriter.Workbook("索书号总表.xlsx")
worksheet=workbook.add_worksheet(u"sheet")
for n in range(1,len(E)+1):
for i in range(len(I)):
worksheet.write("B"+str(n),poplist(E[n-