from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding = 'ascii')
workbook = xlwt.Workbook(encoding = 'utf-8')
workbook = xlrd.open_workbook("io_xls/jdwlsjdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
telephone = dh.telephone()
number_logistics = dh.number_logistics()
weight = dh.weight()
packing = dh.packing()
leaderTel = dh.leaderTel()
other_name = dh.other_name()
other_tel = dh.other_telephone()
company_lg = dh.company_logistics()
ranges =dh.ranges()
# 导入excel
worksheet.write(1,0,number_logistics)
worksheet.write(1,1,weight)
worksheet.write(1,2,packing)
worksheet.write(1,3,name)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/nbajmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
ns = dh.number_seven()
lt = dh.local_time()
name_n = ty.type_hospital()
# 导入excel
worksheet.write(1, 0, ns)
worksheet.write(1, 1, "斗殴")
worksheet.write(1, 2, name_n)
worksheet.write(1, 3, "打架")
worksheet.write(1, 4, lt)
worksheet.write(1, 5, "聚集斗殴")
worksheet.write(1, 6, "丹东市公安局")
worksheet.write(1, 7, "元宝分局")
worksheet.write(1, 8, "于家派出所")
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/zxymb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
telephone = dh.telephone()
identity = dh.identity()
phone = dh.phone()
phone_sn = dh.phone_SN()
nf = dh.number_fifteen()
police = dh.police()
tn = ty.name_myConpany()
address = ty.address()
other_name = dh.other_name()
otel = dh.other_telephone()
type_c = ty.type_myConpany()
type_myConpany = ty.type_myConpany()
safe = dh.safety()
# 导入excel
worksheet.write(1, 0, tn)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/wbmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
education = dh.education()
professional = dh.professional()
safety = dh.safety()
typewb = ty.type_wb()
phone = dh.phone()
phone_sn = dh.phone_SN()
police = dh.police()
ph = dh.other_telephone()
name_w = ty.name_wb()
address = ty.address()
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlrd.open_workbook("io_xls/ghdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
education = dh.education()
professional = dh.professional()
create_job_time = dh.local_time()
safety = dh.safety()
sex = dh.sex()
collde = dh.collde()
other_name = dh.other_name()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, sex)
worksheet.write(1, 2, telephone)
worksheet.write(1, 3, identity)
worksheet.write(1, 4, birthday)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/gxxsdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
identity_code = dh.identity_code()
documents = dh.documents()
nation_code = dh.nation_code()
sex = dh.sex()
time_school = dh.time_school()
sex_code = dh.sex_code()
ranges = dh.ranges()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, identity_code)
worksheet.write(1, 2, documents)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/rydr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
professional = dh.professional()
sex = dh.sex()
lt = dh.local_time()
documents = dh.documents()
dp = dh.department()
address = ty.address()
name_t = ty.name_wb()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, sex)
worksheet.write(1, 2, nation)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/jdwlmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
telephone = dh.telephone()
identity = dh.identity()
other_name = dh.other_name()
other_telephone = dh.other_telephone()
other_identity = dh.other_identity()
leaderTel = dh.phone()
leaderSN = dh.phone_SN()
police = dh.police()
type_net = ty.type_net()
name_j = ty.name_net()
address = ty.address()
# 导入excel
worksheet.write(1, 0, name_j)
worksheet.write(1, 1, address)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/gxmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
identity = dh.identity()
birthday = dh.birthday()
documents = dh.documents()
college = dh.college()
eductional_system = dh.eductional_system()
time_school = dh.time_school()
gx = ty.name_school()
address = ty.address()
ts = ty.type_school()
safe = dh.safety()
tel = dh.telephone()
phone = dh.phone()
phone_sn = dh.phone_SN()
police = dh.police()
other_p = dh.other_telephone()
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/zyjcssmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
create_job_time = dh.local_time()
base = dh.base()
grade = dh.grade()
size = dh.size()
local = dh.local()
name_z = ty.name_company()
# 导入excel
worksheet.write(1, 0, name_z)
worksheet.write(1, 1, "基础的设施")
worksheet.write(1, 2, grade)
worksheet.write(1, 3, base)
worksheet.write(1, 4, size)
worksheet.write(1, 5, local)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("zydr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
ns = dh.number_seven()
sex = dh.sex()
marry = dh.marry()
collde = dh.collde()
time = dh.local_time()
# 导入excel
worksheet.write(1, 0, ns)
worksheet.write(1, 1, name)
worksheet.write(1, 2, identity)
worksheet.write(1, 3, sex)
worksheet.write(1, 4, marry)
worksheet.write(1, 5, collde)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/jzdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
sex = dh.sex()
equipment_number = dh.equipment_number()
identity = dh.identity()
number_three = dh.number_three()
other_name = dh.other_name()
tm = dh.type_medicine()
tel = dh.telephone()
time = dh.local_time()
ranges = dh.ranges()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, sex)
worksheet.write(1, 2, equipment_number)
worksheet.write(1, 3, tel)
worksheet.write(1, 4, identity)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/bwrymb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
sex = dh.sex()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
education = dh.education()
professional = dh.professional()
lt = dh.local_time()
address = ty.address()
address_now = dh.address_now()
name_b = ty.name_company()
# 导入excel
from xls import Property
from xlutils.copy import copy
import xlrd
from type import Type
workbook = xlrd.open_workbook("io_xls/fkxxdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
ty = Type()
# 调用类中的方法
name = dh.name()
nation = dh.nation()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
education = dh.education()
professional = dh.professional()
create_job_time = dh.local_time()
safety = dh.safety()
equipment_number = dh.number_three()
name_f = ty.name_company()
name_b = ty.name_dzjg()
na = dh.other_name()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, telephone)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/jzmb.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
myconpanytype = dh.myConpanyType()
telephone = dh.telephone()
identity = dh.identity()
birthday = dh.birthday()
sex = dh.sex()
collde = dh.collde()
other_name = dh.other_name()
lt = dh.local_time()
ranges = dh.ranges()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, sex)
worksheet.write(1, 2, telephone)
worksheet.write(1, 3, identity)
worksheet.write(1, 4, birthday)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/mqdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
identity = dh.identity()
birthday = dh.birthday()
nt = dh.number_thirteen()
area = dh.area()
pay = dh.pay()
lt = dh.local_time()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, identity)
worksheet.write(1, 2, "")
worksheet.write(1, 3, nt)
worksheet.write(1, 4, area)
worksheet.write(1, 5, pay)
worksheet.write(1, 6, lt)
worksheet.write(1, 7, "丹东市公安局")
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/gndr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
telephone = dh.telephone()
identity = dh.identity()
create_job_time = dh.local_time()
sex = dh.sex()
room_number = dh.number_three()
area = dh.area()
pay = dh.pay()
ranges = dh.ranges()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, sex)
worksheet.write(1, 2, identity)
worksheet.write(1, 3, telephone)
from xls import Property
import xlwt
from xlutils.copy import copy
import xlrd
workbook = xlwt.Workbook(encoding='ascii')
workbook = xlwt.Workbook(encoding='utf-8')
workbook = xlrd.open_workbook("io_xls/gxlxsdr.xls")
# 对数据表格进行复制
old_content = copy(workbook)
worksheet = old_content.get_sheet(0)
# 实例化类
dh = Property()
# 调用类中的方法
name = dh.name()
identity = dh.identity()
birthday = dh.birthday()
documents = dh.documents()
sex = dh.sex()
college = dh.college()
eductional_system = dh.eductional_system()
time_school = dh.time_school()
ranges = dh.ranges()
# 导入excel
worksheet.write(1, 0, name)
worksheet.write(1, 1, documents)
worksheet.write(1, 2, identity)