def txt_to_xls(txt_file):
with open(txt_file, 'r') as f:
file_content = json.load(f, encoding='utf-8')
xls_workbook = xlwt3.Workbook(encoding='utf-8')
xls_sheet = xls_workbook.add_sheet('student')
style = xlwt3.XFStyle()
font = xlwt3.Font()
font.name = '黑体'
style.font = font
for i in range(len(file_content)):
# 写入对应列号
xls_sheet.write(i, 0, i + 1, style)
json_data = file_content[str(i + 1)]
for j in range(len(json_data)):
xls_sheet.write(i, j + 1, json_data[j], style)
xls_workbook.save('student.xls')
def txt_to_xls(txt_file):
with open(txt_file, 'r') as f:
# print(f)
file_content = json.load(f)
print(file_content)
print(file_content[0])
xls_workbook = xlwt3.Workbook()
xls_sheet = xls_workbook.add_sheet('numbers')
style = xlwt3.XFStyle()
font = xlwt3.Font()
font.name = '黑体'
style.font = font
for i in range(len(file_content)):
for j in range(len(file_content[i])):
xls_sheet.write(i, j, file_content[i][j])
xls_workbook.save('numbers.xls')
def txt_to_xls(txt_file):
with open(txt_file, 'r') as f:
# print(f)
file_content = json.load(f)
# print(file_content)
xls_workbook = xlwt3.Workbook()
xls_sheet = xls_workbook.add_sheet('city')
style = xlwt3.XFStyle()
font = xlwt3.Font()
font.name = '黑体'
style.font = font
for i in range(len(file_content)):
# 写入对应列号
xls_sheet.write(i, 0, i + 1, style)
json_data = file_content[str(i + 1)]
print(json_data)
xls_sheet.write(i, 1, json_data)
xls_workbook.save('city.xls')
def create_simple_xls(self):
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime(2010, 12, 5), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save('simple.xls')
def print_from_db(collections):
file_name = "excel_" + datetime.datetime.now().strftime(
"%Y-%m-%d_%H%M%S") + ".xls"
wb = xlwt.Workbook()
ws = wb.add_sheet('0')
# headers = ['п/н', 'Название', 'Дата', 'Ссылка', 'Начальная цена контракта',
# 'Размер обеспечения', 'Несколько заказчиков', 'Победитель', 'Кол-во, ссылка',
# 'Регион', 'Город', 'Телефон', 'ИНН', 'КПП', 'ОГРН']
headers = [
'п/н', 'Название', 'Дата', 'Ссылка', 'Начальная цена контракта',
'Размер обеспечения', 'Несколько заказчиков', 'Победитель', 'Ссылка',
'Регион', 'Телефон'
]
ezxf = xlwt.easyxf
font0, font1, font2, font3 = xlwt.Font(), xlwt.Font(), xlwt.Font(
), xlwt.Font()
style0, style1, style2, style3 = xlwt.XFStyle(), xlwt.XFStyle(
), xlwt.XFStyle(), xlwt.XFStyle()
style4 = ezxf("align: wrap on, vert centre, horiz left")
font0.name = 'Times New Roman'
font0.bold = True
style0.font = font0
font1.bold = False
style1.font = font1
style1.num_format_str = '# ### ##0.00'
font2.colour_index = 4
style2.font = font2
style3.num_format_str = "DD.MM.YYYY"
style3.font = font3
col, row = 0, 0
for head in headers:
ws.write(row, col, head, style0)
col += 1
n = "HYPERLINK"
row += 1
for dt in collections:
col = 0
ws.write(row, col, row)
col += 1
ws.write(row, col, dt['name'], style4)
col += 1
ws.write(row, col, dt['date'], style3)
col += 1
ws.write(row, col,
xlwt.Formula(n + '("{0}";"{1}")'.format(dt['url'], dt['id'])),
style2)
col += 1
ws.write(row, col, dt['maxsum'], style1)
col += 1
ws.write(row, col, dt['garantsum'], style1)
col += 1
ws.write(row, col, dt['garantmix'])
col += 1
ws.write(row, col, dt['winner'], style4)
col += 1
ws.write(
row, col,
xlwt.Formula(n + '("{0}";"{1}")'.format(dt['surls'], dt['sname'])),
style2)
col += 1
ws.write(row, col, dt['region'])
col += 1
# ws.write(row, col, dt['city'])
# col += 1
ws.write(row, col, dt['phone'])
col += 1
# ws.write(row, col, dt['inn'])
# col += 1
# ws.write(row, col, dt['kpp'])
# col += 1
# ws.write(row, col, dt['ogrn'])
row += 1
wb.save(file_name)
return 0
def print_result_col(collections=None):
file_name = "excel_" + datetime.datetime.now().strftime(
"%Y-%m-%d_%H%M%S") + ".xls"
wb = xlwt.Workbook()
ws = wb.add_sheet('0')
headers = [
'п/н', 'Название', 'Дата', 'Ссылка', 'Начальная цена контракта',
'Размер обеспечения', 'Несколько заказчиков', 'Победитель',
'Кол-во, ссылка', 'Регион', 'Город', 'Телефон', 'ИНН', 'КПП', 'ОГРН'
]
ezxf = xlwt.easyxf
font0, font1, font2, font3 = xlwt.Font(), xlwt.Font(), xlwt.Font(
), xlwt.Font()
style0, style1, style2, style3 = xlwt.XFStyle(), xlwt.XFStyle(
), xlwt.XFStyle(), xlwt.XFStyle()
style4 = ezxf("align: wrap on, vert centre, horiz left")
font0.name = 'Times New Roman'
font0.bold = True
style0.font = font0
font1.bold = False
style1.font = font1
style1.num_format_str = '# ### ##0.00'
font2.colour_index = 4
style2.font = font2
style3.num_format_str = "DD.MM.YYYY"
style3.font = font3
col, row = 0, 0
for head in headers:
ws.write(row, col, head, style0)
col += 1
n = "HYPERLINK"
row += 1
for colecttion in collections:
col = 0
ws.write(row, col, row)
col += 1
ws.write(row, col, colecttion.name, style4)
col += 1
ws.write(row, col, colecttion.date, style3)
col += 1
ws.write(
row, col,
xlwt.Formula(
n + '("{0}";"{1}")'.format(colecttion.url, colecttion.id)),
style2)
col += 1
ws.write(row, col, colecttion.maxsum, style1)
col += 1
ws.write(row, col, colecttion.garantsum, style1)
col += 1
mix = 'да' if colecttion.garantMix > 1 else 'нет'
ws.write(row, col, mix)
col += 1
ws.write(row, col, colecttion.winner['name'], style4)
col += 1
if (colecttion.winner['urls'] == 1):
links = 'один'
else:
links = 'поиск'
urls = colecttion.winner['surls']
ws.write(row, col,
xlwt.Formula(n + '("{0}";"{1}")'.format(urls, links)), style2)
col += 1
ws.write(row, col, colecttion.winner['region'])
col += 1
ws.write(row, col, colecttion.winner['city'])
col += 1
ws.write(row, col, colecttion.winner['phone'])
col += 1
ws.write(row, col, colecttion.winner['inn'])
col += 1
ws.write(row, col, colecttion.winner['kpp'])
col += 1
ws.write(row, col, colecttion.winner['ogrn'])
row += 1
wb.save(file_name)
return 0
from datetime import datetime
import xlwt3 as xlwt
font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True
style0 = xlwt.XFStyle()
style0.font = font0
style1 = xlwt.XFStyle()
style1.num_format_str = 'D-MMM-YY'
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 'Test', style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save('example.xls')