コード例 #1
0
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)
コード例 #2
0
ファイル: nbajmb.py プロジェクト: paradise637/import_output 
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, "于家派出所")
コード例 #3
0
ファイル: zxymb.py プロジェクト: paradise637/import_output 
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)
コード例 #4
0
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()
コード例 #5
0
ファイル: ghdr.py プロジェクト: paradise637/import_output 
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)
コード例 #6
0
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)
コード例 #7
0
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)
コード例 #8
0
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)
コード例 #9
0
ファイル: gxmb.py プロジェクト: paradise637/import_output 
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()
コード例 #10
0
ファイル: zyjcssmb.py プロジェクト: paradise637/import_output 
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)
コード例 #11
0
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)
コード例 #12
0
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)
コード例 #13
0
ファイル: bwrymb.py プロジェクト: paradise637/import_output 
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
コード例 #14
0
ファイル: fkxxdr.py プロジェクト: paradise637/import_output 
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)
コード例 #15
0
ファイル: jzmb.py プロジェクト: paradise637/import_output 
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)
コード例 #16
0
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, "丹东市公安局")
コード例 #17
0
ファイル: gndr.py プロジェクト: paradise637/import_output 
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)
コード例 #18
0
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)