def write_xls_content(table_name, rows):
wbk = xlwt.Workbook()
# 新建一个名为Sheet1的excel sheet。此处的cell_overwrite_ok =True是为了能对同一个单元格重复操作。
sheet = wbk.add_sheet('Sheet1', cell_overwrite_ok=True)
# 获取当前日期，得到一个datetime对象如：(2016, 8, 9, 23, 12, 23, 424000)
# 遍历result中的没个元素。
for i in range(len(rows)):
# 对result的每个子元素作遍历，
for j in range(len(rows[i])):
# 将每一行的每个元素按行号i,列号j,写入到excel中。
sheet.write(i, j, rows[i][j])
# 以传递的name+当前日期作为excel名称保存。
table_name = table_name.replace(' ', '_')
wbk.save(combine_file_path('gen/export.xls'))
shutil.move(combine_file_path('gen/export.xls'), combine_file_path('gen/' + table_name))
def file_download():
file_name = request.args.get("fileName")
response = make_response(send_file(combine_file_path('gen/' + file_name)))
response.headers[
"Content-Disposition"] = "attachment; filename={};".format('export.' +
'xls')
return response
def char_to_image(char):
"""
char
"""
des_dir = combine_file_path('resource/char') + '/'
for font in FONT_OBJECTS:
size = font.getsize(char)
scene_text = Image.new('RGBA', size)
draw = ImageDraw.Draw(scene_text)
draw.text((0, 0), char, font=font)
scene_text = np.array(scene_text)
start_index = 0
for i in range(30):
if scene_text[i, :, :].max() == 0:
start_index = i
else:
break
new_area = scene_text[start_index:, :, :]
write_image(des_dir + char + '_' + get_uuid_str() + '.jpg',
255 - new_area)
date： 2020/8/15
-------------------------------------------------
Change Activity:
2020/8/15:
-------------------------------------------------
"""
from llib.cv_utility.image_opt_utility import write_image
from llib.file_utility.file_path_utility import combine_file_path, get_all_files_under_directory
from PIL import Image, ImageDraw, ImageFont
from llib.random_utility.random_utility import fetch_item_from_list
import numpy as np
from llib.random_utility.uuid_utility import get_uuid_str
TTF_PATHS = get_all_files_under_directory(combine_file_path('resource/font'))
FONT_SIZE = 44
def __load_font_objects():
font_lst = []
for path in TTF_PATHS:
font = ImageFont.truetype(path, FONT_SIZE)
font_lst.append(font)
return font_lst
FONT_OBJECTS = __load_font_objects()
def char_to_image(char):
def main():
xls_path = combine_file_path('resource/1.XLS')
content = read_xls_content(xls_path)
File Name： log_util
Description :
Author : 'li'
date： 2020/3/30
-------------------------------------------------
Change Activity:
2020/3/30:
-------------------------------------------------
"""
import datetime
import time
from llib.log_utility.time_format import TimeFormat
from llib.file_utility.file_path_utility import combine_file_path, create_dir
LOG_DIR = combine_file_path('log/')
create_dir(LOG_DIR)
def get_launch_time():
return TimeFormat.date_stamp_to_datetime(time.time()).replace(' ',
'.').replace(
':', '-')
LAUNCH_TIME = get_launch_time()
LOG_TMP_PATH = 'log/log-%s.log' % LAUNCH_TIME
LOG_PATH = LOG_DIR = combine_file_path(LOG_TMP_PATH)
-------------------------------------------------
Change Activity:
2020/8/15:
-------------------------------------------------
"""
import os
from llib.cv_utility.image_opt_utility import read_image, write_image
from llib.cv_utility.image_preprocess.jittering_methods import *
from llib.cv_utility.image_resize_utility import ImageUtility
from llib.file_utility.file_path_utility import combine_file_path, get_all_files_under_directory
import numpy as np
from llib.random_utility.random_utility import fetch_item_from_list
CHAR_DIR = combine_file_path('resource/char')
def __load_char_mapping():
"""
"""
char_mapping = {}
char_paths = get_all_files_under_directory(CHAR_DIR)
for p in char_paths:
_, name = os.path.split(p)
label = name.split('_')[0]
img = read_image(p)
if label not in char_mapping:
char_mapping[label] = []
char_mapping[label] = img