예제 #1
0
파일: main.py 프로젝트: Stone-by/Python-
document = Document()

NomerRabot = input("Nomer work: ")
NomerGroop = input("Nomer group: ")
Prepod = input("Teacher: ")
Student = input("Student: ")
NameWork = input("Name work: ")
Goal = input("Goal: ")
Code = input("Code: ")
PostanovkaZadachi = input("Zadacha: ")
Test = input("Test: ")
End = input("End: ")
Information = input("Information: ")

with open(Code, "r") as file:
    for line in file:
        Text = line

paragraph = document.add_paragraph('Номер отчета: ' + NomerRabot)
paragraph = document.add_paragraph('Номер группы: ' + NomerGroop)
paragraph = document.add_paragraph('Преподаватель: ' + Prepod)
paragraph = document.add_paragraph('Студент: ' + Student)
paragraph = document.add_paragraph('Название работы: ' + NameWork)
paragraph = document.add_paragraph('Цель работы: ' + Goal)
paragraph = document.add_paragraph('Код: ' + Text)
paragraph = document.add_paragraph('Тест: ')
document.add_picture(Test, width=Inches(1.0))
paragraph = document.add_paragraph('Вывод: ' + End)
paragraph = document.add_paragraph('Источники: ' + Information)

document.save('test1.docx')
예제 #2
0
def writedocxwithrealxls(file_path, filename, orders):
    document = Document()
    style = document.styles['Normal']
    font = style.font
    font.name = 'Times New Roman'
    font.size = Pt(9)
    for section in document.sections:
        section.orientation = 1 # 1 is LANDSCAPE, 0 is POTRAIT
        section.page_width = Mm(297) # for A4 Paper
        section.page_height = Mm(210)

        section.left_margin = Inches(0.5)
        section.right_margin = Inches(0.5)
        section.top_margin = Inches(0.5)
        section.bottom_margin = Inches(0.5)


    for item in orders:
        table = document.add_table(rows=0, cols=16)
        table.columns[0].width = Inches(0.45)
        table.columns[1].width = Inches(1.25)
        table.columns[2].width = Inches(1.65)
        table.columns[3].width = Inches(0.50)
        table.columns[4].width = Inches(0.55)
        table.columns[5].width = Inches(0.65)
        table.columns[6].width = Inches(0.75)
        table.columns[7].width = Inches(0.05)
        table.columns[8].width = Inches(0.05)
        table.columns[9].width = Inches(0.45)
        table.columns[10].width = Inches(1.25)
        table.columns[11].width = Inches(1.65)
        table.columns[12].width = Inches(0.50)
        table.columns[13].width = Inches(0.55)
        table.columns[14].width = Inches(0.65)
        table.columns[15].width = Inches(0.75)


        #Delivery Notes Title
        row_one = table.add_row().cells
        row_one[0].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_one[0].merge(row_one[6])
        row_one[0].paragraphs[0].add_run(item[0][0]).bold = True

        # Copy
        row_one[9].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_one[9].merge(row_one[15])
        row_one[9].paragraphs[0].add_run(item[0][0]).bold = True

        #Distributor Name, Customer Name, Order Number
        row_two = table.add_row().cells
        row_two[0].merge(row_two[1])
        row_two[0].text = item[1][0]
        row_two[0].paragraphs[0].add_run('\n' + item[2][0])
        row_two[2].text = item[1][1]
        row_two[2].paragraphs[0].add_run('\n' + item[2][1])
        row_two[2].paragraphs[0].add_run('\n' + item[3][0])
        row_two[2].paragraphs[0].add_run('\n' + item[4][0])
        row_two[3].merge(row_two[6])
        row_two[3].text = item[1][2]
        row_two[3].paragraphs[0].add_run('\n' + item[2][2])
        row_two[3].paragraphs[0].add_run('\n' + item[3][1])
        row_two[3].paragraphs[0].add_run('\n' + item[4][1])
        row_two[3].paragraphs[0].add_run('\n' + item[5][0])
        #Copy
        row_two[9].merge(row_two[10])
        row_two[9].text = item[1][0]
        row_two[9].paragraphs[0].add_run('\n' + item[2][0])
        row_two[11].text = item[1][1]
        row_two[11].paragraphs[0].add_run('\n' + item[2][1])
        row_two[11].paragraphs[0].add_run('\n' + item[3][0])
        row_two[11].paragraphs[0].add_run('\n' + item[4][0])
        row_two[12].merge(row_two[15])
        row_two[12].text = item[1][2]
        row_two[12].paragraphs[0].add_run('\n' + item[2][2])
        row_two[12].paragraphs[0].add_run('\n' + item[3][1])
        row_two[12].paragraphs[0].add_run('\n' + item[4][1])
        row_two[0].paragraphs[0].add_run('\n' + item[5][0])
        #Driver Message
        row_seven = table.add_row().cells
        row_seven[0].merge(row_seven[6])
        row_seven[0].text = item[6][0]
        #Copy
        row_seven[9].merge(row_seven[15])
        row_seven[9].text = item[6][0]
        # Product Detail Title
        row_nine = table.add_row().cells
        row_nine[0].merge(row_nine[6])
        row_table1 = row_nine[0].add_table(rows=0, cols=6)
        row_table1.style = 'TableGrid'
        row_table1.columns[0].width = Inches(0.45)
        row_table1.columns[1].width = Inches(2.0)
        row_table1.columns[2].width = Inches(0.50)
        row_table1.columns[3].width = Inches(0.55)
        row_table1.columns[4].width = Inches(0.65)
        row_table1.columns[5].width = Inches(0.75)
        row_table_cells1 = row_table1.add_row().cells
        row_table_cells1[0].paragraphs[0].add_run('Code').bold = True
        row_table_cells1[0].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_table_cells1[1].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_table_cells1[1].paragraphs[0].add_run('Description').bold = True
        row_table_cells1[2].paragraphs[0].add_run('UOM').bold = True
        row_table_cells1[3].paragraphs[0].add_run('QTY').bold = True
        row_table_cells1[4].paragraphs[0].add_run('Price').bold = True
        row_table_cells1[5].paragraphs[0].add_run('Amount').bold = True
        #Copy
        row_nine[9].merge(row_nine[15])
        row_table2 = row_nine[9].add_table(rows=0, cols=6)
        row_table2.style = 'TableGrid'
        row_table2.columns[0].width = Inches(0.45)
        row_table2.columns[1].width = Inches(2.0)
        row_table2.columns[2].width = Inches(0.50)
        row_table2.columns[3].width = Inches(0.55)
        row_table2.columns[4].width = Inches(0.65)
        row_table2.columns[5].width = Inches(0.75)
        row_table_cells2 = row_table2.add_row().cells
        row_table_cells2[0].paragraphs[0].add_run('Code').bold = True
        row_table_cells2[0].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_table_cells2[1].alignment = WD_ALIGN_PARAGRAPH.CENTER
        row_table_cells2[1].paragraphs[0].add_run('Description').bold = True
        row_table_cells2[2].paragraphs[0].add_run('UOM').bold = True
        row_table_cells2[3].paragraphs[0].add_run('QTY').bold = True
        row_table_cells2[4].paragraphs[0].add_run('Price').bold = True
        row_table_cells2[5].paragraphs[0].add_run('Amount').bold = True

        for products in item[8]:
            #Product Detail
            row_product1 = row_table1.add_row().cells
            row_product1[0].text = str(products[0]).replace('.0','')
            row_product1[1].text = str(products[1])
            row_product1[2].text = str(products[2])
            row_product1[3].text = str(products[3]).replace('.0','')
            row_product1[4].text = str(products[4]).replace('.0','')
            row_product1[5].text = str(products[5]).replace('.0','')
            #Copy
            row_product2 = row_table2.add_row().cells
            row_product2[0].text = str(products[0]).replace('.0','')
            row_product2[1].text = str(products[1])
            row_product2[2].text = str(products[2])
            row_product2[3].text = str(products[3]).replace('.0','')
            row_product2[4].text = str(products[4]).replace('.0','')
            row_product2[5].text = str(products[5]).replace('.0','')

        #Total Products
        row_eleven1 = row_table1.add_row().cells
        row_eleven1[0].text = ''
        row_eleven1[1].text = item[9][0]
        row_eleven1[2].text = ''
        row_eleven1[3].text = str(item[9][1]).replace('.0','')
        row_eleven1[4].text = ''
        row_eleven1[5].text = str(item[9][2]).replace('.0','')
        #Copy
        row_eleven2 = row_table2.add_row().cells
        row_eleven2[0].text = ''
        row_eleven2[1].text = item[9][0]
        row_eleven2[2].text = ''
        row_eleven2[3].text = str(item[9][1]).replace('.0','')
        row_eleven2[4].text = ''
        row_eleven2[5].text = str(item[9][2]).replace('.0','')

        #Tax Informaiton
        row_twelve = table.add_row().cells
        row_twelve[0].merge(row_twelve[6])
        row_twelve[0].text = item[10][0]
        #Copy
        row_twelve[9].merge(row_twelve[15])
        row_twelve[9].text = item[10][0]

        row_thirteen = table.add_row().cells
        row_fourteen = table.add_row().cells
        row_fifteen = table.add_row().cells
        #Buyer, Seller
        row_sixteen = table.add_row().cells
        row_sixteen[0].merge(row_sixteen[2])
        row_sixteen[0].text = item[11][0]
        row_sixteen[4].merge(row_sixteen[6])
        row_sixteen[4].text = item[11][1]
        #Copy
        row_sixteen[9].merge(row_sixteen[11])
        row_sixteen[9].text = item[11][0]
        row_sixteen[13].merge(row_sixteen[15])
        row_sixteen[13].text = item[11][1]

        document.add_page_break()

    document.save('%s%s.docx' % (file_path, filename))
예제 #3
0
    print("Start parsing " + s_file_name + ":")
    with open(s_absolute_path) as fp:
        html = fp.read()
        article = newspaper.Article(url='http://example.com/test-url')
        article.set_html(html)
        article.parse()
        article.nlp()

        s_article_title = article.title

        response = requests.get(article.top_image, stream=True)
        b_image = io.BytesIO(response.content)

        s_article_text = article.text

        # add article-title and (if available) -subtitle to docx
        document.add_heading(s_article_title, level=2)
        #document.add_heading(s_article_sub_title, level=2)

        document.add_picture(b_image, width=Inches(3.25))

        # add text content (paragraph) to docx
        paragraph = document.add_paragraph(s_article_text)

        document.add_page_break()
#-------------------------------------------------------------------------------------

# save it
print("Save document")
document.save(s_docx_absl_path + "/" + s_output_filename)
예제 #4
0
파일: m_tv.py 프로젝트: braimp/pySpider-2
def get_detail():
    f_error = open('tv_error.txt', 'a+', encoding='utf-8')
    f_img = open('tv_img.txt', 'a+', encoding='utf-8')
    # f_final=open('tv_final.txt','a+',encoding='utf-8')
    root = 'http://m.1988.tv'
    wordrootname = '1988_病虫害word'
    htmlrootname = '1988_病虫害html'
    imgrootname = '1988_病虫害img'
    if not os.path.exists(wordrootname):
        os.mkdir(wordrootname)
    if not os.path.exists(htmlrootname):
        os.mkdir(htmlrootname)
    if not os.path.exists(imgrootname):
        os.mkdir(imgrootname)
    for line in open('tv_final.1.txt', 'r', encoding='utf-8'):
        line = eval(line)
        fname = line[1].replace('?', '').replace('|', '').replace(
            '"',
            '').replace('>', '').replace('<', '').replace('*', '').replace(
                '*', '').replace('\\', '').replace(':', '').replace('/', '')
        print(fname)
        if 'baik' in line[0]:
            path1 = './' + wordrootname + '/' + fname + '_' + line[0][
                7:].replace('.html', '')
            path2 = './' + htmlrootname + '/' + fname + '_' + line[0][
                7:].replace('.html', '')
        else:
            path1 = './' + wordrootname + '/' + fname + '_' + line[0][
                14:].replace('.html', '')
            path2 = './' + htmlrootname + '/' + fname + '_' + line[0][
                14:].replace('.html', '')
        # print(path)
        # if os.path.exists(path1+'.docx'):
        #     print(path1+'已存在')
        #     continue
        # url=root+line[0]
        # url='http://www.tv.com/newshow.asp?id=50163'
        # line[1]='白菜要丰产施肥必须有技法'
        # print(url)
        doc = Document()
        # for i in range(3):
        #     try:
        #         req=requests.get(url,timeout=15)
        #         req.encoding='utf-8'
        #         bsObj=BeautifulSoup(req.text,'html.parser')
        #         #病虫害
        #         content=bsObj.find('div',class_='content')
        #         img_list=content.find_all('img')
        #         #写入标题
        #         break
        #     except:
        #         pass
        # if content==None  :
        #     print(url+'未取到数据')
        #     f_error.write(str(line)+'\n')
        #     continue
        # if len(img_list)>0:
        #     print(url+'存在图片')
        #     f_img.write(str(line)+'\n')
        #     continue
        line[1] = line[1].replace('\r\n', '').strip()
        content = BeautifulSoup(line[2].replace('</p', '\n</p'), 'html.parser')
        img_list = content.find_all('mip-img')
        # f_final.write(str(line+[str(content)])+'\n')
        # continue

        doc.add_heading(line[1], level=0)
        skin_text = str(content)
        for im in img_list:
            src = im.attrs['src']
            print(src)
            newSrc = d_load(src, imgrootname)
            #替换内容
            skin_text = skin_text.replace(src,
                                          '../' + imgrootname + '/' + newSrc)
            try:
                doc.add_picture('./' + imgrootname + '/' + newSrc,
                                width=Inches(3))
            except:
                pass

        #写入文本内容
        # content_word=remove_control_characters(str(content.get_text()))
        doc.add_paragraph(u'%s' % (content.get_text()))
        doc.save(path1 + '.docx')
        #写入html

        fp = open(path2 + '.html', 'w', encoding='utf-8')
        fp.write(
            '<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body><h1>'
            + str(line[1]) + '</h1>' + str(skin_text) +
            '</body></html>')  #写入数据
        fp.close()
        # break
    f_error.close()
    f_img.close()
예제 #5
0
#!usr/bin/env/python3
#-*- coding: utf-8 -*-
__author__ = 'Michael Shen'
#pip install python-docx
from docx import Document
from docx.shared import Inches

string = '文字内容'
images = 'haha.jpg'  # 保存在本地的图片
doc = Document()  # doc对象
doc.add_paragraph(string)  # 添加文字
doc.add_picture(images, width=Inches(2))  # 添加图, 设置宽度
doc.save('word文档.docx')  # 保存路径
예제 #6
0
    def browse_folder(self):
        directory = QtWidgets.QFileDialog.getSaveFileName(
            self, "Сохранение резюме",
            getenv('USERPROFILE') + r"\Desktop", 'Документ Word (*.docx)')
        if directory[0] != "":
            resume_savefile = Document()
            resume_savefile.save(directory[0])

            resume = Document(docx=directory[0])

            sex = self.sex_comboBox.currentIndex()
            sex_text = self.sex_comboBox.currentText()
            second_name = self.secondname.displayText()
            name = self.name.displayText()
            patronymic = self.patronymic.displayText()
            post = self.post.displayText()
            phone_number = self.phoneNumber.displayText()
            professional_skills = self.professional_skills.toPlainText()
            email = self.email.displayText()
            birth_date = self.birthDate.date().toPyDate()
            personal_qualities = self.personal_qualities.toPlainText()
            edu_level = self.edu_level.currentText()
            experience = self.experience.toPlainText()
            birth_year = int(str(birth_date)[0:4])
            birth_month = str(birth_date)[5:7]
            birth_day = str(birth_date)[8:10]

            birth_date = birth_day + "." + birth_month + "." + str(birth_year)
            age = str(2019 - birth_year)

            if sex == 1:
                sex = "Мужчина, "
            else:
                sex = "Женщина, "

            resume.add_heading('Резюме', level=0)
            resume.add_heading(text=str(second_name) + " " + str(name) + " " +
                               str(patronymic),
                               level=1)
            resume.add_heading(sex + age + " лет, дата рождения: " +
                               birth_date,
                               level=1)

            if photopath[0] != "":
                resume.add_picture(photopath[0], width=Inches(1.25))

            p = resume.add_paragraph(text="", style=None)
            p.add_run('Должность: ').bold = True
            p.add_run(post)

            if phone_number != "":
                mobile_phone = resume.add_paragraph(text="", style=None)
                mobile_phone.add_run('Моб. телефон: ').bold = True
                mobile_phone.add_run(phone_number)

            if email != "":
                em = resume.add_paragraph(text="", style=None)
                em.add_run('E-mail: ').bold = True
                em.add_run(email)

            edu = resume.add_paragraph(text="", style=None)
            edu.add_run('Уровень образования: ').bold = True
            edu.add_run(edu_level)

            if personal_qualities != "":
                personal_qualities_title = resume.add_paragraph(text="",
                                                                style=None)
                personal_qualities_title.add_run(
                    'Персональные качества: ').bold = True

                resume.add_paragraph(text=personal_qualities, style=None)

            if professional_skills != "":
                professional_skills_title = resume.add_paragraph(text="",
                                                                 style=None)
                professional_skills_title.add_run(
                    'Профессиональные навыки: ').bold = True

                resume.add_paragraph(text=professional_skills, style=None)

            if experience != "":
                experience_title = resume.add_paragraph(text="", style=None)
                experience_title.add_run('Опыт работы:').bold = True

                resume.add_paragraph(text=experience, style=None)

            # database_file = open('resumaker_database.rdb', 'a', encoding="utf-8")
            # write_string = "\n" + name + "\t" + second_name + "\t" + post + "\t" + sex_text + "\t" + age +\
            #                "\t" + edu_level
            # database_file.write(write_string)
            # database_file.close()

            db = open('resumaker_database.rdb', 'r+', encoding="utf-8")
            if db.read() != "":
                db.write("\n")
            db.write(name + "," + second_name + "," + post + "," +\
               age + "," + edu_level + "," + directory[0])
            db.close()

            resume.save(directory[0])
예제 #7
0
from docx.shared import Inches
from docx.shared import RGBColor
import docx

#创建word文档
file = docx.Document()

#添加段落字体颜色
file.add_paragraph().add_run('这里是字体颜色测试_1').font.color.rgb = RGBColor(
    167, 2, 25)
font_1 = file.add_paragraph().add_run('这里是字体颜色测试')
font_1.font.color.rgb = RGBColor(0, 255, 0)

#添加图片
file.add_picture('213.jpg', width=Inches(2))

#保存为word文档
file.save('mytest2.docx')
예제 #8
0
        fig.suptitle("Analisis grafico de la variable {}".format(i))
        axs[0, 0].hist(valor3, bins=conj, density=True)
        axs[0, 0].set_title("histograma")
        axs[0, 0].set(ylabel="densidad")
        axs[0, 1].boxplot(valor3, sym='ko', whis=1.5)
        axs[0, 1].set_title("Diagrama de cajas")
        #axs[0,1].set(xlabel="intervalos", ylabel="densidad")
        axs[1, 0].plot(conj[:len(conj) - 1], his.cumsum(), "o-")
        axs[1, 0].set_title("Grafico de ojiva")
        axs[1, 0].set(xlabel="observaciones", ylabel="densidad acumulada")
        axs[1, 1].step(x, y)
        axs[1, 1].set_title("distribucion empirica")
        nombre = "grafico_variable_{}.png".format(i)
        plt.savefig(nombre)
        #time.sleep(1)
        proyecto.add_picture(nombre, width=Inches(6))
        """
             |parrafo
             |
            """
        proyecto.add_paragraph(
            fp.escritura(i,
                         var1=round(stats.skew(valor3), 2),
                         var2=round(stats.kurtosis(valor3), 2),
                         var3=round(np.percentile(valor3, 50), 2),
                         var4=round(np.percentile(valor3, 75), 2),
                         var5=round(np.percentile(valor3, 25), 2)))
        proyecto.add_page_break()

    else:
        proyecto.add_heading(
예제 #9
0
def find_best_binary_model(
        X,
        y,
        model_search_spaces,
        k_outer_fold=5,
        skip_outer_folds=[],
        k_inner_fold=5,
        skip_inner_folds=[],
        n_initial_points=5,
        n_calls=10,
        calibrated=False,
        ensemble=False,
        loss_metric='average_precision',
        peeking_metrics=[],
        report_level=11,
        size_variance_validation=20,
        skopt_func=gp_minimize,
        verbose=False,
        build_final_model=True
    ):
    """Finds best binary calibrated classification model and optionally
    generate a report doing a nested cross validation. In the inner
    cross validation, doing a Bayesian Search, the best parameters are found.
    In the outer cross validation, the model is validated.
    Finally, the whole procedure is used for the full dataset to return
    the best possible model.


    Parameters
    ----------
    X : np.array
        Feature set.

    y : np.array
        Classification target to predict. For the moment only binary labels are allowed, and
        values are supposed to be {0, 1} or {-1, 1}

    model_search_spaces : Dict[str : List[List[skopt.Space]]
        Dict of models to try inside of the inner loops. For each model, there is
        the corresponding list of space objects to delimit where the parameters live,
        including the pipeline postprocess to make. It admits also an option to set
        undersampling_majority_class method. It admits two values, True or False. If True
        it builds an ensemble model in the inner loop by creating many balanced folds
        by using the minority class with a undersampling of the majority class. If using
        this option, it also admits an Int max_k_undersampling, in order to limit the number of
        splits made for this (because if the imbalance ratio is for example 1000:1, it will
        create 1000 splits, which can be too much).

    k_outer_fold : int, default=5
        Number of folds for the outer cross-validation.

    skip_outer_folds : list, default=None
        If set, list of folds to skip during the loop.

    k_inner_fold : int, default=5
        Number of folds for the inner cross-validation.

    skip_inner_folds : list, default=None
        If set, list of folds to skip during the loop.

    n_initial_points : int, default=5
        Number of initial points to use in Bayesian Optimization.

    n_calls : int, default=5
        Number of additional calls to use in Bayesian Optimization.

    calibrated : bool, default=False
        If True, all models are calibrated using CalibratedClassifierCV

    ensemble : bool, default=False
        If True, an ensemble model is built in the inner training loop. Otherwise,
        a model fitted with the whole inner dataset will be built.

    loss_metric : str, default='auc'
        Metric to use in order to find best parameters in Bayesian Search. Options:
        - roc_auc
        - average_precision
        - neg_brier_score
        - neg_log_loss
        - histogram_width

    peeking_metrics : List[str], default=[]
        If not empty, in the report there will be a comparison between the metric of
        evaluation on the inner fold and the list of metrics in peeking_metrics.

    report_levels : int, default=11
        If 00, no report is returned.
        If 01, plots are not included. All peeking-metrics are evaluated on the outer fold for each inner-fold model.
        If 10, plots are included. No evaluation of peeking-metrics on the outer fold for each inner-fold model.
        If 11, a full report (it can be more time consuming).

    size_variance_validation : int, default=20
        Number of samples to use to check variance of different models.

    skopt_func : callable, default=gp_minimize
        Minimization function of the skopt library to be used.

    verbose : bool, default=False
        If True, you can trace the progress in the terminal.

    build_final_model : bool, default=True
        If False, no final model is built (only the report doc is returned). It can be convenient
        during the experimental phase.

    Returns
    -------
    model : Model trained with the full dataset using the same procedure
            as in the inner cross validation.
    report_doc : Document python-docx if report_level > 0. Otherwise, None
    report_dfs : Dict of dataframes, one key for each model in model_search_spaces.
                 each key, a dataframe with all inner models built with their
                 params and loss_metric.
    """
# TODO: Add new parameter information
    # Validation of inputs
    X, y = check_X_y(X, y,
                     accept_sparse=['csc', 'csr', 'coo'],
                     force_all_finite=False, allow_nd=True)
    counter = Counter(y)
    if len(counter) > 2:
        raise NotImplementedError("Multilabel classification is not yet implemented")
    y_values = set(counter.keys())
    if y_values != {-1, 1} and y_values != {0, 1}:
        raise NotImplementedError("Values of target are expected to be in {0, 1} or in {-1, 1}")

    if not _validate_model_search_space(model_search_spaces):
        raise ValueError("model_search_spaces is not well formed")

    if not _validate_folds(k_outer_fold, skip_outer_folds, k_inner_fold, skip_inner_folds):
        raise ValueError("Folds parameters are not well formed")

    if not _validate_bayesian_search(n_initial_points, n_calls, skopt_func):
        raise ValueError("Bayesian search parameters are not well formed")

    if not is_supported(loss_metric):
        raise NotImplementedError(f"Loss metric {loss_metric} is not implemented.")

    if not isinstance(peeking_metrics, list):
        raise ValueError("Peeking metrics must be a list of str")

    for metric in peeking_metrics:
        if not is_supported(metric):
            raise NotImplementedError(f"Metric {metric} is not implemented.")

    if not isinstance(calibrated, bool):
        raise ValueError("calibrated must be a boolean")

    if not isinstance(ensemble, bool):
        raise ValueError("ensemble must be a boolean")

    if not isinstance(verbose, bool):
        raise ValueError("verbose must be a boolean")

    if not isinstance(build_final_model, bool):
        raise ValueError("build_final_model must be a boolean")

    if not isinstance(size_variance_validation, int):
        raise ValueError("size_variance_validation must be an int")

    if size_variance_validation < 0 or size_variance_validation > len(y):
        raise ValueError("size_variance_validation cannot be negative nor bigger than number of instances")

    if size_variance_validation > 0 and size_variance_validation < len(counter):
        raise ValueError("size_variance_validation, if not zero, cannot be less than number of classes")

    if report_level not in [0, 1, 10, 11]:
        raise ValueError("report_level must be either 0, 1, 10 or 11")

    # End of validation of inputs

    if calibrated:
        ensemble = True

    if loss_metric not in peeking_metrics:
        peeking_metrics.append(loss_metric)

    if report_level > 0:
        outer_report_doc = Document()
        section = outer_report_doc.sections[0]
        section.page_width = Inches(reporting_width(report_level, peeking_metrics))
        outer_report_doc.add_heading('Report of training', 0)

        write_intro_doc(
            outer_report_doc, y, model_search_spaces,
            k_outer_fold, skip_outer_folds, k_inner_fold,
            skip_inner_folds, n_initial_points, n_calls, ensemble,
            calibrated, loss_metric, size_variance_validation,
            skopt_func)
        inner_report_doc = Document()
        section = inner_report_doc.sections[0]
        section.page_width = Inches(reporting_width(report_level, peeking_metrics))
    else:
        outer_report_doc = None
        inner_report_doc = None

    X_val_var = []
    y_val_var = []
    if size_variance_validation > 0:
        X, X_val_var, y, y_val_var = train_test_split(X, y, test_size=size_variance_validation, random_state=42, stratify=y)

    outer_cv = StratifiedKFold(n_splits=k_outer_fold)
    dict_inner_models = []
    list_report_dfs = []
    outer_Xs = []
    outer_ys = []
    folds_index = []
    if inner_report_doc:
        inner_report_doc.add_heading(f'Report of inner trainings', level=1)
    for k, (train_index, test_index) in enumerate(outer_cv.split(X, y)):
        if k not in skip_outer_folds:
            folds_index.append(k)
            if inner_report_doc:
                inner_report_doc.add_heading(f'Report of inner training in fold {k} of outer Cross Validation', level=2)
            X_hold_out = X[test_index] if report_level in [1, 11] else []
            y_hold_out = y[test_index] if report_level in [1, 11] else []
            inner_model, model_params, model_comments, report_dfs = train_inner_model(
                X=X[train_index], y=y[train_index], model_search_spaces=model_search_spaces,
                X_hold_out=X_hold_out, y_hold_out=y_hold_out,
                k_inner_fold=k_inner_fold, skip_inner_folds=skip_inner_folds,
                n_initial_points=n_initial_points, n_calls=n_calls, ensemble=ensemble,
                calibrated=calibrated, loss_metric=loss_metric, peeking_metrics=peeking_metrics,
                verbose=verbose, skopt_func=skopt_func, report_doc=inner_report_doc)
            dict_inner_models.append({'model': inner_model,
                                 'params': model_params,
                                 'comments': model_comments})
            list_report_dfs.append(report_dfs)
            outer_Xs.append(X[test_index])
            outer_ys.append(y[test_index])
    if outer_report_doc:
        outer_report_doc.add_heading(f'Report of validation of the models in the outer Cross Validation', level=1)
    add_plots = True if report_level > 9 else False
    report_dfs = merge_report_dfs(*list_report_dfs)
    evaluate_models(
        dict_models=dict_inner_models, Xs=outer_Xs, ys=outer_ys,
        X_val_var=X_val_var, y_val_var=y_val_var,
        folds_index=folds_index, report_doc=outer_report_doc,
        loss_metric=loss_metric, peeking_metrics=peeking_metrics,
        add_plots=add_plots, report_dfs=report_dfs
    )
    # After assessing the procedure, we repeat it on the full dataset:
    final_model = None
    if build_final_model:
        final_model, _, _, _ = train_inner_model(
                X=X, y=y, model_search_spaces=model_search_spaces,
                X_hold_out=[], y_hold_out=[],
                k_inner_fold=k_inner_fold, skip_inner_folds=skip_inner_folds,
                n_initial_points=n_initial_points, n_calls=n_calls, ensemble=ensemble,
                calibrated=calibrated, loss_metric=loss_metric, peeking_metrics=[],
                verbose=verbose, skopt_func=skopt_func, report_doc=None)
    return final_model, merge_docs(outer_report_doc, inner_report_doc), report_dfs
예제 #10
0
def generuj_rozkaz(request):
    query1 = Dane.objects.filter(typ='przepustkę jednorazową', transport__contains='kolejowym w klasie 2').order_by(
        '-stopien_id', 'nazwisko')
    query2 = Dane.objects.filter(typ='urlop', transport__contains='kolejowym w klasie 2').order_by('-stopien_id',
                                                                                                     'nazwisko')
    query3 = Dane.objects.filter(typ='przepustkę jednorazową', transport__contains='autobusowym w').order_by(
        '-stopien_id', 'nazwisko')
    query4 = Dane.objects.filter(typ='urlop', transport__contains='autobusowym w').order_by('-stopien_id',
                                                                                               'nazwisko')

    THIS_FOLDER = os.path.dirname(os.path.abspath(__file__))
    generated_rozkaz = os.path.join(THIS_FOLDER, 'demo.docx')
    document = Document()

    dodaj_naglowek(document)

    licznik = 1

    tables = []

    # tworzenie tabeli osobna funkcja
    if query1:
        p = document.add_paragraph(switch_litery(licznik) + 'na przepustkę jednorazową – środek transportu PKP:')
        # p.paragraph_format.left_indent = Inches (0.25)
        table1 = dodaj_tabele(document, query1)
        tables.append(table1)
        p.paragraph_format.space_before = Pt(12)

    if query2:
        licznik += 1
        p = document.add_paragraph(switch_litery(licznik) + 'na urlop – środek transportu PKP:')
        # p.paragraph_format.left_indent = Inches (0.25)
        table2 = dodaj_tabele(document, query2)
        tables.append(table2)
        p.paragraph_format.space_before = Pt(12)
    if query3:
        licznik += 1
        p = document.add_paragraph(switch_litery(licznik) + 'na przepustkę jednorazową – środek transportu PKS:')
        # p.paragraph_format.left_indent = Inches (0.25)
        table3 = dodaj_tabele(document, query3)
        tables.append(table3)
        p.paragraph_format.space_before = Pt(12)
    if query4:
        licznik += 1
        p = document.add_paragraph(switch_litery(licznik) + 'na urlop – środek transportu PKS:')
        # p.paragraph_format.left_indent = Inches (0.25)
        table4 = dodaj_tabele(document, query4)
        tables.append(table4)
        p.paragraph_format.space_before = Pt(12)

    # ustawianie parametrów dokumentu
    style = document.styles['Normal']
    font = style.font
    font.name = 'Times New Roman'
    font.size = Pt(12)

    # ustawianie szerokosci tabelek
    i = 1
    for tbl in tables:
        for row in tbl.rows:
            j = 1
            row.height_rule = WD_ROW_HEIGHT.EXACTLY
            row.height = Inches(0.20)
            for cell in row.cells:
                if j == 1:  # 1)
                    cell.width = Inches(0.1)
                if j == 2:  # stopien
                    cell.width = Inches(1.25)
                if j == 3:  # imie
                    cell.width = Inches(0.9)
                if j == 4:  # nazwisko
                    cell.width = Inches(1.5)
                if j == 5:
                    cell.width = Inches(2.4)
                if j == 6:
                    cell.width = Inches(0.6)
                if j == 7:
                    cell.width = Inches(1.2)
                j += 1
            i += 1

    dodaj_stopke(document)
    # ustawianie marginesow
    sections = document.sections
    for section in sections:
        section.top_margin = Cm(1.5)
        section.bottom_margin = Cm(1.59)
        section.left_margin = Cm(0.75)
        section.right_margin = Cm(1.32)

    # download
    document.save(generated_rozkaz)
    response = HttpResponse(open(generated_rozkaz, 'rb').read())
    response['Content-Type'] = 'text/plain'
    previous_month = datetime.datetime.today().month - 1
    previous_month_name = calendar.month_name[previous_month]  # ustawienie nazwy pliku z rozkazem
    response['Content-Disposition'] = 'attachment; filename= rozkaz"{}".docx'.format(previous_month_name)

    return response
예제 #11
0
document = Document()

document.add_heading('Document Title', 0)

p = document.add_paragraph('A plain paragraph having some ')
p.add_run('bold').bold = True
p.add_run(' and some ')
p.add_run('italic.').italic = True

document.add_heading('Heading, level 1', level=1)
document.add_paragraph('Intense quote', style='IntenseQuote')

document.add_paragraph('first item in unordered list', style='ListBullet')
document.add_paragraph('first item in ordered list', style='ListNumber')

document.add_picture('butterfly.jpg', width=Inches(1.25))

table = document.add_table(rows=1, cols=3)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Qty'
hdr_cells[1].text = 'Id'
hdr_cells[2].text = 'Desc'
recordset = [[1, "101", "Spam"], [2, "42", "Eggs"],
             [3, "631", "Spam, spam, eggs, and spam"]]
for item in recordset:
    row_cells = table.add_row().cells
    row_cells[0].text = str(item[0])
    row_cells[1].text = str(item[1])
    row_cells[2].text = item[2]

document.add_page_break()
예제 #12
0
def clonarTemplateYAgregarFinding(doc, indexNros, language, jsonFinding):
    nroParagraph = indexNros[0]
    nroTable = indexNros[1]
    nroPageBreak = indexNros[2]
    urls = jsonFinding['resourceAf']
    refUrls = jsonFinding['RECOMMENDATION']['URLS']
    page_break = doc.paragraphs[nroPageBreak]
    templateParag = deepcopy(doc.paragraphs[nroParagraph])
    # Titulo finding
    runNro = 9
    if not indexNros[3]: runNro = 7
    templateParag.runs[runNro].text = jsonFinding['TITLE']
    # Agarra pagebreak anterior y pone el nuevo titulo abajo
    page_break._p.addnext(templateParag._p)
    # Agregar todo el contenido
    new_tbl = deepcopy(doc.tables[nroTable])
    p, pb = templateParag._p, page_break._p
    new_pb = deepcopy(pb)
    p.addnext(new_pb)
    # Clonamos toda la informacion que es parte del finding (Observacion, tabla, impacto, etc.)
    #Excepto el parrafo de la imagen ya que si lo clonamos se puede romper el formato
    obsTitle = deepcopy(doc.paragraphs[nroParagraph + 2])
    obsText = deepcopy(doc.paragraphs[nroParagraph + 3])
    urlTitle = deepcopy(doc.paragraphs[nroParagraph + 4])
    obsNote = deepcopy(doc.paragraphs[nroParagraph + 7])
    legendTable = deepcopy(doc.paragraphs[nroParagraph + 8])
    legendFigure = deepcopy(doc.paragraphs[nroParagraph + 10])
    impactTitle = deepcopy(doc.paragraphs[nroParagraph + 11])
    impactDesc = deepcopy(doc.paragraphs[nroParagraph + 12])
    likelihoodTitle = deepcopy(doc.paragraphs[nroParagraph + 13])
    likelihoodDesc = deepcopy(doc.paragraphs[nroParagraph + 14])
    recomendTitle = deepcopy(doc.paragraphs[nroParagraph + 15])
    recomendNote = deepcopy(doc.paragraphs[nroParagraph + 16])
    recomendText = deepcopy(doc.paragraphs[nroParagraph + 17])
    referenceTitle = deepcopy(doc.paragraphs[nroParagraph + 18])
    referenceLinkLegend = deepcopy(doc.paragraphs[nroParagraph + 19])
    # Cargamos la informacion en base a lo que se tenga
    # URLS RECOMENDACIONES
    if len(refUrls) >= 1:
        for url in refUrls:
            urlRef = deepcopy(doc.paragraphs[nroParagraph + 20])
            urlRef.text = url
            p.addnext(urlRef._p)
        if len(refUrls) > 1:
            referenceLinkLegend.text = constants.enlacesRecomendacion_EN if language else constants.enlacesRecomendacion_ES
            p.addnext(referenceLinkLegend._p)
        else:
            p.addnext(referenceLinkLegend._p)
        p.addnext(referenceTitle._p)
    recomendText.text = jsonFinding['RECOMMENDATION']['TITLE']
    p.addnext(recomendText._p)
    p.addnext(recomendNote._p)
    p.addnext(recomendTitle._p)
    p.addnext(likelihoodDesc._p)
    p.addnext(likelihoodTitle._p)
    impactDesc.text = jsonFinding['IMPLICATION']
    p.addnext(impactDesc._p)
    p.addnext(impactTitle._p)
    p.addnext(legendFigure._p)
    #Agregamos imagen si es que hay
    figureText = doc.paragraphs[nroParagraph + 9]
    figureText.clear()
    figureText.add_run()
    image_path = add_screenshot(jsonFinding)
    if image_path:
        figureText.runs[0].add_picture(image_path,width=Inches(5.33), height=Inches(4.0))
        delete_screenshot(image_path)
    para = deepcopy(figureText)
    p.addnext(para._p)
    p.addnext(legendTable._p)
    mid_tbl = deepcopy(doc.tables[nroTable + 1])
    p.addnext(mid_tbl._tbl)
    if jsonFinding['OBSERVATION']['NOTE']:
        agregarNota(obsNote, jsonFinding['OBSERVATION']['NOTE'])
    else:
        obsNote.text = ""
    p.addnext(obsNote._p)
    for url in urls:
        urlExample = deepcopy(doc.paragraphs[nroParagraph + 5])
        urlExample.text = url
        p.addnext(urlExample._p)
    if len(urls) == 1:
        urlTitle.text = constants.urlAfectada_EN if language else constants.urlAfectada_ES
        p.addnext(urlTitle._p)
    else:
        p.addnext(urlTitle._p)
    obsText.text = jsonFinding['OBSERVATION']['TITLE']
    obsText.text+= add_cves(jsonFinding)
    p.addnext(obsText._p)
    p.addnext(obsTitle._p)
    # Espacio vacio para respetar el formato
    p.addnext(deepcopy(doc.paragraphs[nroParagraph + 1])._p)
    p.addnext(new_tbl._tbl)
    addFindingInfo(new_tbl, language, urls)
예제 #13
0
def recover_docx(bounding_boxs, output_name, image):
    line_tables = []
    current_line = 0
    # current_bbox = 0
    i = 0
    bounding_boxs.sort(key=functools.cmp_to_key(compare_table))
    # bounding_boxs.sort(key=functools.cmp_to_key(compare_table))
    while i < len(bounding_boxs):
        if bounding_boxs[i][5] == 0:
            if bounding_boxs[i][0] == '':
                i += 1
                continue
            str_on_line = []
            str_on_line.append(bounding_boxs[i][0])
            j = i + 1
            if j < len(bounding_boxs):
                mi = min(bounding_boxs[i][4] + bounding_boxs[i][2],
                         bounding_boxs[j][4] + bounding_boxs[j][2])
                ma = max(bounding_boxs[i][2], bounding_boxs[j][2])
            # min - max >= 55
            while j < len(bounding_boxs) and (mi - ma >= 40):
                if bounding_boxs[j][0] == '':
                    j += 1
                    break
                str_on_line.append(bounding_boxs[j][0])
                j += 1
                if j < len(bounding_boxs):
                    mi = min(bounding_boxs[i][4] + bounding_boxs[i][2],
                             bounding_boxs[j][4] + bounding_boxs[j][2])
                    ma = max(bounding_boxs[i][2], bounding_boxs[j][2])
            i = j
            if len(str_on_line) > 0:
                line_tables.append((str_on_line, 0))
        elif bounding_boxs[i][5] != 0:
            line_tables.append(((bounding_boxs[i][1], bounding_boxs[i][2],
                                 bounding_boxs[i][3], bounding_boxs[i][4]), 1))
            i += 1

    if os.path.exists(outputName) == False:
        dc = Document()
        dc.save(outputName)
    document = Document(outputName)
    for row in line_tables:
        if row[1] == 0:
            table = document.add_table(rows=1, cols=len(row[0]))
            i = 0
            row_cells = table.rows[0].cells
            for cell in row[0]:
                p = row_cells[i].add_paragraph(cell)
                p.alignment = WD_TABLE_ALIGNMENT.CENTER
                i += 1
        if row[1] == 1:
            cropped_table = image[row[0][1]:row[0][1] + row[0][3],
                                  row[0][0]:row[0][0] + row[0][2]]
            # cv2.imshow('cropped_table', cropped_table)
            # cv2.waitKey(0)
            cv2.imwrite('cropped_table.jpg', cropped_table)
            table = document.add_table(rows=1, cols=1)
            row_cells = table.add_row().cells
            p = row_cells[0].add_paragraph()
            p.alignment = WD_TABLE_ALIGNMENT.CENTER
            r = p.add_run()
            img_width = image.shape[0]
            print(img_width)
            img_height = image.shape[1]
            print(img_height)
            print('row[0][3]', row[0][3])
            print('height', row[0][3] / img_height)
            # r.add_picture('cropped_table.jpg')
            document.add_picture('cropped_table.jpg',
                                 width=Inches(6.0),
                                 height=Inches(row[0][3] / img_height * 5))
            i += 1

    document.save(outputName)
예제 #14
0
#!/usr/bin/env python
# -*- coding: UTF-8 -*-

from docx import Document
from docx.shared import Inches
from docx.shared import Pt
from random import sample
from random import shuffle
from random import seed
from random import randint

document = Document()
sections = document.sections
for section in sections:
    section.top_margin = Inches(.5)
    section.bottom_margin = Inches(.5)
    section.left_margin = Inches(.5)
    section.right_margin = Inches(.5)
tests = raw_input("How many tests? ")
for x in range(int(tests)):
    paragraph = document.add_paragraph('Name:_____________________________________________________________________________Date:_________________Hour:__________________')

    table = document.add_table(rows=4, cols=2)
    a = table.cell(0,0)
    b = table.cell(0,1)
    A = a.merge(b)
    cell = table.cell(0,0)
    cell.text = "Taya tries to throw a piece of paper into the trash.  She fires the paper at " + str(randint(80,100)/10.0)+ "m/s. The trash can is "+ str(randint(31,59)/10.0)+ " meters away.\nAt what angle must Taya throw the paper to hit the trash can?" 
    cell = table.cell(1,0)
    cell.text = "STEP 1: Write the given values, with variables, for this problem.\n\n\n\n\n\n\n"
    cell = table.cell(1,1)
예제 #15
0
class Describe_Cell(object):
    def it_knows_what_text_it_contains(self, text_get_fixture):
        cell, expected_text = text_get_fixture
        text = cell.text
        assert text == expected_text

    def it_can_replace_its_content_with_a_string_of_text(
            self, text_set_fixture):
        cell, text, expected_xml = text_set_fixture
        cell.text = text
        assert cell._tc.xml == expected_xml

    def it_knows_its_width_in_EMU(self, width_get_fixture):
        cell, expected_width = width_get_fixture
        assert cell.width == expected_width

    def it_can_change_its_width(self, width_set_fixture):
        cell, value, expected_xml = width_set_fixture
        cell.width = value
        assert cell.width == value
        assert cell._tc.xml == expected_xml

    def it_provides_access_to_the_paragraphs_it_contains(
            self, paragraphs_fixture):
        cell = paragraphs_fixture
        paragraphs = cell.paragraphs
        assert len(paragraphs) == 2
        count = 0
        for idx, paragraph in enumerate(paragraphs):
            assert isinstance(paragraph, Paragraph)
            assert paragraph is paragraphs[idx]
            count += 1
        assert count == 2

    def it_provides_access_to_the_tables_it_contains(self, tables_fixture):
        # test len(), iterable, and indexed access
        cell, expected_count = tables_fixture
        tables = cell.tables
        assert len(tables) == expected_count
        count = 0
        for idx, table in enumerate(tables):
            assert isinstance(table, Table)
            assert tables[idx] is table
            count += 1
        assert count == expected_count

    def it_can_add_a_paragraph(self, add_paragraph_fixture):
        cell, expected_xml = add_paragraph_fixture
        p = cell.add_paragraph()
        assert cell._tc.xml == expected_xml
        assert isinstance(p, Paragraph)

    def it_can_add_a_table(self, add_table_fixture):
        cell, expected_xml = add_table_fixture
        table = cell.add_table(rows=0, cols=0)
        assert cell._tc.xml == expected_xml
        assert isinstance(table, Table)

    def it_can_merge_itself_with_other_cells(self, merge_fixture):
        cell, other_cell, merged_tc_ = merge_fixture
        merged_cell = cell.merge(other_cell)
        cell._tc.merge.assert_called_once_with(other_cell._tc)
        assert isinstance(merged_cell, _Cell)
        assert merged_cell._tc is merged_tc_
        assert merged_cell._parent is cell._parent

    # fixtures -------------------------------------------------------

    @pytest.fixture(params=[
        ('w:tc', 'w:tc/w:p'),
        ('w:tc/w:p', 'w:tc/(w:p, w:p)'),
        ('w:tc/w:tbl', 'w:tc/(w:tbl, w:p)'),
    ])
    def add_paragraph_fixture(self, request):
        tc_cxml, after_tc_cxml = request.param
        cell = _Cell(element(tc_cxml), None)
        expected_xml = xml(after_tc_cxml)
        return cell, expected_xml

    @pytest.fixture(params=[
        ('w:tc', 'w:tc/(w:tbl'),
        ('w:tc/w:p', 'w:tc/(w:p, w:tbl'),
    ])
    def add_table_fixture(self, request):
        tc_cxml, after_tc_cxml = request.param
        # the table has some overhead elements, also a blank para after since
        # it's in a cell.
        after_tc_cxml += (
            '/(w:tblPr/w:tblW{w:type=auto,w:w=0},w:tblGrid),w:p)')
        cell = _Cell(element(tc_cxml), None)
        expected_xml = xml(after_tc_cxml)
        return cell, expected_xml

    @pytest.fixture
    def merge_fixture(self, tc_, tc_2_, parent_, merged_tc_):
        cell, other_cell = _Cell(tc_, parent_), _Cell(tc_2_, parent_)
        tc_.merge.return_value = merged_tc_
        return cell, other_cell, merged_tc_

    @pytest.fixture
    def paragraphs_fixture(self):
        return _Cell(element('w:tc/(w:p, w:p)'), None)

    @pytest.fixture(params=[
        ('w:tc', 0),
        ('w:tc/w:tbl', 1),
        ('w:tc/(w:tbl,w:tbl)', 2),
        ('w:tc/(w:p,w:tbl)', 1),
        ('w:tc/(w:tbl,w:tbl,w:p)', 2),
    ])
    def tables_fixture(self, request):
        cell_cxml, expected_count = request.param
        cell = _Cell(element(cell_cxml), None)
        return cell, expected_count

    @pytest.fixture(params=[
        ('w:tc', ''),
        ('w:tc/w:p/w:r/w:t"foobar"', 'foobar'),
        ('w:tc/(w:p/w:r/w:t"foo",w:p/w:r/w:t"bar")', 'foo\nbar'),
        ('w:tc/(w:tcPr,w:p/w:r/w:t"foobar")', 'foobar'),
        ('w:tc/w:p/w:r/(w:t"fo",w:tab,w:t"ob",w:br,w:t"ar",w:br)',
         'fo\tob\nar\n'),
    ])
    def text_get_fixture(self, request):
        tc_cxml, expected_text = request.param
        cell = _Cell(element(tc_cxml), None)
        return cell, expected_text

    @pytest.fixture(params=[
        ('w:tc/w:p', 'foobar', 'w:tc/w:p/w:r/w:t"foobar"'),
        ('w:tc/w:p', 'fo\tob\rar\n',
         'w:tc/w:p/w:r/(w:t"fo",w:tab,w:t"ob",w:br,w:t"ar",w:br)'),
        ('w:tc/(w:tcPr, w:p, w:tbl, w:p)', 'foobar',
         'w:tc/(w:tcPr, w:p/w:r/w:t"foobar")'),
    ])
    def text_set_fixture(self, request):
        tc_cxml, new_text, expected_cxml = request.param
        cell = _Cell(element(tc_cxml), None)
        expected_xml = xml(expected_cxml)
        return cell, new_text, expected_xml

    @pytest.fixture(params=[
        ('w:tc', None),
        ('w:tc/w:tcPr', None),
        ('w:tc/w:tcPr/w:tcW{w:w=25%,w:type=pct}', None),
        ('w:tc/w:tcPr/w:tcW{w:w=1440,w:type=dxa}', 914400),
    ])
    def width_get_fixture(self, request):
        tc_cxml, expected_width = request.param
        cell = _Cell(element(tc_cxml), None)
        return cell, expected_width

    @pytest.fixture(params=[
        ('w:tc', Inches(1), 'w:tc/w:tcPr/w:tcW{w:w=1440,w:type=dxa}'),
        ('w:tc/w:tcPr/w:tcW{w:w=25%,w:type=pct}', Inches(2),
         'w:tc/w:tcPr/w:tcW{w:w=2880,w:type=dxa}'),
    ])
    def width_set_fixture(self, request):
        tc_cxml, new_value, expected_cxml = request.param
        cell = _Cell(element(tc_cxml), None)
        expected_xml = xml(expected_cxml)
        return cell, new_value, expected_xml

    # fixture components ---------------------------------------------

    @pytest.fixture
    def merged_tc_(self, request):
        return instance_mock(request, CT_Tc)

    @pytest.fixture
    def parent_(self, request):
        return instance_mock(request, Table)

    @pytest.fixture
    def tc_(self, request):
        return instance_mock(request, CT_Tc)

    @pytest.fixture
    def tc_2_(self, request):
        return instance_mock(request, CT_Tc)
예제 #16
0
    def hash(self, RutaEx):
        noms= MetodosHash.archYrutas()
        xl= ex.Excel()
        doc= docx.Document()

        bandetitulo= 0
        cadeTemp= ""
        dirs2= []
        dirs= []
        DatosFlag= 0
        path= xl.DatosEx(DatosFlag, RutaEx)
        DatosFlag= 1
        extension= xl.DatosEx(DatosFlag, RutaEx)
        fecha_actual= time.strftime("%m/%d/%Y")
        hora_actual= time.strftime("%H:%M:%S")
        cont= 0
        Descripcion= xl.Ex(RutaEx)
        cont_para= 0
        ImaExt= ".png"

        noms.NomCarpe(dirs, path, dirs2)
        dirs2= []
        dirs2= xl.NomCarpesRuta(RutaEx)
        os.system("cls")

        for i in dirs2:
            tupla= ()
            cont_tupla= 0
            a1= 0
            a2= ""
            a3= ""
            bande= 0
            cont_pixeles= 0
            pixeles= 70
            dire= ""
            DatosFlag= 0
            path2= xl.DatosEx(DatosFlag, RutaEx)
            path3= path2
            dire= "\\"+i
            path2+=dire
            path3+=dire
            cadeTemp= noms.NomArch(path2, extension)
            diraux= dirs2
            dirtemporal= diraux[cont].split(" ")
            diraux[cont]= dirtemporal[0]

            print("---------------"+diraux[cont]+"---------------")
            for x in cadeTemp:
                aux= "\\"+x
                path2+= "\\"+x
                hashh, bande= noms.getsha256file(path2)

                if bande== 0:
                    cont_tupla+= 1
                    a1= cont_tupla
                    a2= hashh
                    a3= x
                    tupla2= ((a1, a2, a3),)
                    tupla+= tupla2

                    print("Nombre del archivo: "+x)
                    print("Hash: "+hashh)
                    print("Algoritmo: SHA256")
                    print("")
                    cont_pixeles+= 1
                elif bande>=1:
                    pass
                path2= path2.rstrip(aux)

            print(f"Fecha actual: {fecha_actual}")
            print(f"Hora actual: {hora_actual}")
            print("--------------------------------------------")

            cont_pixeles+= 1
            for h in range(cont_pixeles):
                pixeles+= 50
            pixeles+= 45
            screenshoty= pyautogui.screenshot(region=(1, -0.5, 850, pixeles))
            screenshoty.save(path3+"\\"+diraux[cont]+".png")
            cont+= 1
            os.system("cls")
            pixeles= 70

            try:
                if bandetitulo==0:
                    doc.add_paragraph(xl.TituloWord(RutaEx)).alignment= WD_ALIGN_PARAGRAPH.CENTER
                    bandetitulo= 1
                else:
                    pass
                doc.add_paragraph("\n")
                doc.add_paragraph(Descripcion[cont_para]).alignment= WD_ALIGN_PARAGRAPH.JUSTIFY
            except:
                Descripcion.append("Descripción")
                doc.add_paragraph("\n")
                doc.add_paragraph(Descripcion[cont_para]).alignment= WD_ALIGN_PARAGRAPH.JUSTIFY
            tabla= doc.add_table(rows= 0, cols= 3, style= "Table Grid")
            for c1, c2, c3 in tupla:
                row_cells= tabla.add_row().cells
                row_cells[0].text= str(c1)
                row_cells[1].text= c2
                row_cells[2].text= c3
            cont_para+= 1
            Imas= noms.NomArch(path2, ImaExt)
            for j in range(len(Imas)):
                auxi= "\\"+Imas[j]
                path3+= auxi
                doc.add_picture(path3, width= Inches(6.56))
                path3= path3.rstrip(auxi)

        DatosFlag= 2
        keep= xl.DatosEx(DatosFlag, RutaEx)
        doc.save(keep)
예제 #17
0
class DescribeSection(object):
    def it_knows_its_start_type(self, start_type_get_fixture):
        section, expected_start_type = start_type_get_fixture
        assert section.start_type is expected_start_type

    def it_can_change_its_start_type(self, start_type_set_fixture):
        section, new_start_type, expected_xml = start_type_set_fixture
        section.start_type = new_start_type
        assert section._sectPr.xml == expected_xml

    def it_knows_its_page_width(self, page_width_get_fixture):
        section, expected_page_width = page_width_get_fixture
        assert section.page_width == expected_page_width

    def it_can_change_its_page_width(self, page_width_set_fixture):
        section, new_page_width, expected_xml = page_width_set_fixture
        section.page_width = new_page_width
        assert section._sectPr.xml == expected_xml

    def it_knows_its_page_height(self, page_height_get_fixture):
        section, expected_page_height = page_height_get_fixture
        assert section.page_height == expected_page_height

    def it_can_change_its_page_height(self, page_height_set_fixture):
        section, new_page_height, expected_xml = page_height_set_fixture
        section.page_height = new_page_height
        assert section._sectPr.xml == expected_xml

    def it_knows_its_page_orientation(self, orientation_get_fixture):
        section, expected_orientation = orientation_get_fixture
        assert section.orientation is expected_orientation

    def it_can_change_its_orientation(self, orientation_set_fixture):
        section, new_orientation, expected_xml = orientation_set_fixture
        section.orientation = new_orientation
        assert section._sectPr.xml == expected_xml

    def it_knows_its_page_margins(self, margins_get_fixture):
        section, margin_prop_name, expected_value = margins_get_fixture
        value = getattr(section, margin_prop_name)
        assert value == expected_value

    def it_can_change_its_page_margins(self, margins_set_fixture):
        section, margin_prop_name, new_value, expected_xml = (
            margins_set_fixture)
        setattr(section, margin_prop_name, new_value)
        assert section._sectPr.xml == expected_xml

    # fixtures -------------------------------------------------------

    @pytest.fixture(params=[
        ('w:sectPr/w:pgMar{w:left=120}', 'left_margin', 76200),
        ('w:sectPr/w:pgMar{w:right=240}', 'right_margin', 152400),
        ('w:sectPr/w:pgMar{w:top=-360}', 'top_margin', -228600),
        ('w:sectPr/w:pgMar{w:bottom=480}', 'bottom_margin', 304800),
        ('w:sectPr/w:pgMar{w:gutter=600}', 'gutter', 381000),
        ('w:sectPr/w:pgMar{w:header=720}', 'header_distance', 457200),
        ('w:sectPr/w:pgMar{w:footer=840}', 'footer_distance', 533400),
        ('w:sectPr/w:pgMar', 'left_margin', None),
        ('w:sectPr', 'top_margin', None),
    ])
    def margins_get_fixture(self, request):
        sectPr_cxml, margin_prop_name, expected_value = request.param
        section = Section(element(sectPr_cxml))
        return section, margin_prop_name, expected_value

    @pytest.fixture(params=[
        ('w:sectPr', 'left_margin', Inches(1),
         'w:sectPr/w:pgMar{w:left=1440}'),
        ('w:sectPr', 'right_margin', Inches(0.5),
         'w:sectPr/w:pgMar{w:right=720}'),
        ('w:sectPr', 'top_margin', Inches(-0.25),
         'w:sectPr/w:pgMar{w:top=-360}'),
        ('w:sectPr', 'bottom_margin', Inches(0.75),
         'w:sectPr/w:pgMar{w:bottom=1080}'),
        ('w:sectPr', 'gutter', Inches(0.25), 'w:sectPr/w:pgMar{w:gutter=360}'),
        ('w:sectPr', 'header_distance', Inches(1.25),
         'w:sectPr/w:pgMar{w:header=1800}'),
        ('w:sectPr', 'footer_distance', Inches(1.35),
         'w:sectPr/w:pgMar{w:footer=1944}'),
        ('w:sectPr', 'left_margin', None, 'w:sectPr/w:pgMar'),
        ('w:sectPr/w:pgMar{w:top=-360}', 'top_margin', Inches(0.6),
         'w:sectPr/w:pgMar{w:top=864}'),
    ])
    def margins_set_fixture(self, request):
        sectPr_cxml, property_name, new_value, expected_cxml = request.param
        section = Section(element(sectPr_cxml))
        expected_xml = xml(expected_cxml)
        return section, property_name, new_value, expected_xml

    @pytest.fixture(params=[
        ('w:sectPr/w:pgSz{w:orient=landscape}', WD_ORIENT.LANDSCAPE),
        ('w:sectPr/w:pgSz{w:orient=portrait}', WD_ORIENT.PORTRAIT),
        ('w:sectPr/w:pgSz', WD_ORIENT.PORTRAIT),
        ('w:sectPr', WD_ORIENT.PORTRAIT),
    ])
    def orientation_get_fixture(self, request):
        sectPr_cxml, expected_orientation = request.param
        section = Section(element(sectPr_cxml))
        return section, expected_orientation

    @pytest.fixture(params=[
        (WD_ORIENT.LANDSCAPE, 'w:sectPr/w:pgSz{w:orient=landscape}'),
        (WD_ORIENT.PORTRAIT, 'w:sectPr/w:pgSz'),
        (None, 'w:sectPr/w:pgSz'),
    ])
    def orientation_set_fixture(self, request):
        new_orientation, expected_cxml = request.param
        section = Section(element('w:sectPr'))
        expected_xml = xml(expected_cxml)
        return section, new_orientation, expected_xml

    @pytest.fixture(params=[
        ('w:sectPr/w:pgSz{w:h=2880}', Inches(2)),
        ('w:sectPr/w:pgSz', None),
        ('w:sectPr', None),
    ])
    def page_height_get_fixture(self, request):
        sectPr_cxml, expected_page_height = request.param
        section = Section(element(sectPr_cxml))
        return section, expected_page_height

    @pytest.fixture(params=[
        (None, 'w:sectPr/w:pgSz'),
        (Inches(2), 'w:sectPr/w:pgSz{w:h=2880}'),
    ])
    def page_height_set_fixture(self, request):
        new_page_height, expected_cxml = request.param
        section = Section(element('w:sectPr'))
        expected_xml = xml(expected_cxml)
        return section, new_page_height, expected_xml

    @pytest.fixture(params=[
        ('w:sectPr/w:pgSz{w:w=1440}', Inches(1)),
        ('w:sectPr/w:pgSz', None),
        ('w:sectPr', None),
    ])
    def page_width_get_fixture(self, request):
        sectPr_cxml, expected_page_width = request.param
        section = Section(element(sectPr_cxml))
        return section, expected_page_width

    @pytest.fixture(params=[
        (None, 'w:sectPr/w:pgSz'),
        (Inches(4), 'w:sectPr/w:pgSz{w:w=5760}'),
    ])
    def page_width_set_fixture(self, request):
        new_page_width, expected_cxml = request.param
        section = Section(element('w:sectPr'))
        expected_xml = xml(expected_cxml)
        return section, new_page_width, expected_xml

    @pytest.fixture(params=[
        ('w:sectPr', WD_SECTION.NEW_PAGE),
        ('w:sectPr/w:type', WD_SECTION.NEW_PAGE),
        ('w:sectPr/w:type{w:val=continuous}', WD_SECTION.CONTINUOUS),
        ('w:sectPr/w:type{w:val=nextPage}', WD_SECTION.NEW_PAGE),
        ('w:sectPr/w:type{w:val=oddPage}', WD_SECTION.ODD_PAGE),
        ('w:sectPr/w:type{w:val=evenPage}', WD_SECTION.EVEN_PAGE),
        ('w:sectPr/w:type{w:val=nextColumn}', WD_SECTION.NEW_COLUMN),
    ])
    def start_type_get_fixture(self, request):
        sectPr_cxml, expected_start_type = request.param
        section = Section(element(sectPr_cxml))
        return section, expected_start_type

    @pytest.fixture(params=[
        ('w:sectPr/w:type{w:val=oddPage}', WD_SECTION.EVEN_PAGE,
         'w:sectPr/w:type{w:val=evenPage}'),
        ('w:sectPr/w:type{w:val=nextPage}', None, 'w:sectPr'),
        ('w:sectPr', None, 'w:sectPr'),
        ('w:sectPr/w:type{w:val=continuous}', WD_SECTION.NEW_PAGE, 'w:sectPr'),
        ('w:sectPr/w:type', WD_SECTION.NEW_PAGE, 'w:sectPr'),
        ('w:sectPr/w:type', WD_SECTION.NEW_COLUMN,
         'w:sectPr/w:type{w:val=nextColumn}'),
    ])
    def start_type_set_fixture(self, request):
        initial_cxml, new_start_type, expected_cxml = request.param
        section = Section(element(initial_cxml))
        expected_xml = xml(expected_cxml)
        return section, new_start_type, expected_xml
예제 #18
0
    def create_ppt(self, ppt_dir_path, sel):
        # 如果文件夹不存在就创建一个
        if not os.path.exists(ppt_dir_path):
            os.makedirs(ppt_dir_path)

        SLD_LAYOUT_TITLE_AND_CONTENT = 6  # 6代表ppt模版为空
        prs = Presentation()  # 实例化ppt

        # # 获取完整html
        # sel = self.get_html_data()
        # 获取标题
        xpath_title = "//div[@class='doc-title']/text()"
        title = "".join(sel.xpath(xpath_title).extract()).strip()
        # 获取内容
        xpath_content_p = "//div[@class='content singlePage wk-container']/div/p/img"
        xpath_content_p_list = sel.xpath(xpath_content_p)
        xpath_content_p_url_list=[]
        for imgs in xpath_content_p_list:
            xpath_content = "./@data-loading-src|./@data-src|./@src"
            contents_list = imgs.xpath(xpath_content).extract()
            xpath_content_p_url_list.append(contents_list)

        img_path_list = []  # 保存下载的图片路径,方便后续图片插入ppt和删除图片
        # 下载图片到指定目录
        for index, content_img_p in enumerate(xpath_content_p_url_list):
            p_img_path_list=[]
            for index_1,img_one in enumerate(content_img_p):
                one_img_saved_path = os.path.join(ppt_dir_path, "{}_{}.jpg".format(index,index_1))
                self.download_img.download_one_img(img_one, one_img_saved_path)
                p_img_path_list.append(one_img_saved_path)

            p_img_max_shape = 0
            for index,p_img_path in enumerate(p_img_path_list):
                img_shape = cv2.imread(p_img_path).shape
                if p_img_max_shape<img_shape[0]:
                    p_img_max_shape = img_shape[0]
                    index_max_img = index
            img_path_list.append(p_img_path_list[index_max_img])


        print(img_path_list)
        # 获取下载的图片中最大的图片的尺寸
        img_shape_max=[0,0]
        for img_path_one in img_path_list:
            img_path_one_shape = cv2.imread(img_path_one).shape
            if img_path_one_shape[0]>img_shape_max[0]:
                img_shape_max = img_path_one_shape
        # 把图片统一缩放最大的尺寸
        for img_path_one in img_path_list:
            cv2.imwrite(img_path_one,cv2.resize(cv2.imread(img_path_one),(img_shape_max[1],img_shape_max[0])))
        # img_shape_path = img_path_list[0]
        # 获得图片的尺寸
        # img_shape = cv2.imread(img_shape_path).shape
        # 把像素转换为ppt中的长度单位emu,默认dpi是720
        # 1厘米=28.346像素=360000
        # 1像素 = 12700emu
        prs.slide_width = img_shape_max[1] * 12700  # 换算单位
        prs.slide_height = img_shape_max[0] * 12700

        for img_path_one in img_path_list:
            left = Inches(0)
            right = Inches(0)
            # width = Inches(1)
            slide_layout = prs.slide_layouts[SLD_LAYOUT_TITLE_AND_CONTENT]
            slide = prs.slides.add_slide(slide_layout)
            pic = slide.shapes.add_picture(img_path_one, left, right, )
            print("insert {} into pptx success!".format(img_path_one))
            # os.remove(img_path_one)

        for root,dirs,files in os.walk(ppt_dir_path):
            for file in files:
                if file.endswith(".jpg"):
                    img_path = os.path.join(root,file)
                    os.remove(img_path)

        prs.save(os.path.join(ppt_dir_path, title + ".pptx"))
        print("download {} success!".format(os.path.join(ppt_dir_path, title + ".pptx")))
예제 #19
0
    def handle_starttag(self, tag, attrs):
        if tag == EM:
            self.italic = True
        elif tag == P:
            if not self.list_level:
                self.paragraph = self.document.add_paragraph()
            paragraph_format = self.paragraph.paragraph_format
            paragraph_format.alignment = WD_PARAGRAPH_ALIGNMENT.JUSTIFY
            paragraph_format.space_after = Pt(STANDART_PT)
            paragraph_format.first_line_indent = Cm(
                1.5)  # Inches(STANDART_INCHES + 0.3)
            #   paragraph_format.left_indent = Inches(STANDART_INCHES)
            paragraph_format.line_spacing_rule = WD_LINE_SPACING.ONE_POINT_FIVE
            if self.isBlockQuote:  # it's here because in html <blockquote><p></p></blockquote>
                paragraph_format.first_line_indent = Inches(0)
                paragraph_format.left_indent = Inches(STANDART_INCHES)
                paragraph_format.space_before = Pt(STANDART_PT)
                paragraph_format.space_after = Pt(STANDART_PT)
                paragraph_format.alignment = WD_PARAGRAPH_ALIGNMENT.LEFT
        elif tag == STRONG:
            self.bold = True
        elif tag in [H1, H2, H3, H4, H5, H6]:
            self.h = int(tag[1])
        elif tag == UL:
            self.list_level += 1
        elif tag == LI:
            self.paragraph = self.document.add_paragraph()
            self.need_dot_li = True
            self.font = self.normal_font
            self.size = self.normal_size
        elif tag == IMG:
            url = attrs[0][1]

            response = requests.get(url)
            picture = response.content
            with open(ABS_PATH.format(PICTURE_NAME), 'wb') as file:
                file.write(picture)
            try:
                self.document.add_picture(ABS_PATH.format(PICTURE_NAME),
                                          width=Inches(4),
                                          height=Inches(3))
                last_paragraph = self.document.paragraphs[-1]
                last_paragraph.alignment = WD_PARAGRAPH_ALIGNMENT.CENTER
                last_paragraph.space_after = Pt(10)
                last_paragraph.line_spacing_rule = WD_LINE_SPACING.ONE_POINT_FIVE
                self.paragraph = self.document.add_paragraph()

                #last_paragraph.keep_with_next = False
            except Exception as e:
                print(e)
                print('ERROR WITH IMAGE {}'.format(url))
        elif tag == A:
            self.hyperlink = attrs[0][1]
        elif tag == BLOCKQUOTE:
            self.isBlockQuote = True
        # TABLE SECTION
        elif tag == TABLE:
            self.table_mode = True
        elif tag == THEAD:
            self.table_thead_mode = True
        elif tag == TH:
            pass
        elif tag == TR:
            if not self.table_thead_mode:
                self.table.add_row()
        elif tag == TD:
            pass
        # END TABLE SECTION
        elif tag == CODE:
            paragraph_format = self.paragraph.paragraph_format
            paragraph_format.alignment = WD_PARAGRAPH_ALIGNMENT.LEFT
            paragraph_format.line_spacing_rule = WD_LINE_SPACING.SINGLE
            paragraph_format.first_line_indent = Inches(0)
            self.italic = True
            self.size = self.code_size
            self.font = self.code_font
예제 #20
0
document = Document()

document.add_heading('Document Title', 0)

p = document.add_paragraph('A plain paragraph having some ')
p.add_run('bold').bold = True
p.add_run(' and some ')
p.add_run('italic.').italic = True

document.add_heading('Heading, level 1', level=1)
document.add_paragraph('Intense quote', style='IntenseQuote')

document.add_paragraph('first item in unordered list', style='ListBullet')
document.add_paragraph('first item in ordered list', style='ListNumber')

document.add_picture('test.jpg', width=Inches(1.25))

table = document.add_table(rows=1, cols=3)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Qty'
hdr_cells[1].text = 'Id'
hdr_cells[2].text = 'Desc'
#for item in recordset:
#    row_cells = table.add_row().cells
#    row_cells[0].text = str(item.qty)
#    row_cells[1].text = str(item.id)
#    row_cells[2].text = item.desc

document.add_page_break()

document.save('demo.docx')
예제 #21
0
    for index, subList in enumerate(masterList[(mlSplit + 1):]):
        try:
            student = list2[index]
            app = f'Wind Ensemble: {student}'
            subList.append(app)
        except IndexError:
            pass

from docx import Document
from docx.shared import Inches
from docx.shared import Pt

x = Document()
y = x.sections
outputSection = y[0]
outputSection.page_height = Inches(4)
outputSection.page_width = Inches(6)
for row, nestedList in output.items():
    for index, seat in enumerate(nestedList):
        par = x.add_paragraph()
        run = par.add_run(f'{row}, Seat {index}')
        font = run.font
        font.size = Pt(16)
        font.bold = True

        for name in seat:
            par = x.add_paragraph()
            run = par.add_run(name)
            font = run.font
            font.size = Pt(13)
예제 #22
0
# Press ⌃R to execute it or replace it with your code.
# Press Double ⇧ to search everywhere for classes, files, tool windows, actions, and settings.

from docx import Document
from docx.shared import Inches
import pyttsx3


def speak(text):
    pyttsx3.speak(text)


document = Document()

# profile picture
document.add_picture('images.jpeg', width=Inches(2.0))

#name phone number and email details
name = input('what is your name ? ')
speak('Hello' + name + 'How are you today ?')
phone_number = input('what is your phone number ? ')
speak('what is your phone number ? ')
email = '*****@*****.**'

document.add_paragraph(name + '%' + phone_number + '/' + email)
# about me
document.add_heading('About me')
about_me = input('Tell me about yourself')
document.add_paragraph(about_me)

# work experience
예제 #23
0
    def make_puzzle(self, filename = 'puzzle'):
        difficulty = self.diff
        option = self.option
        if difficulty == 1:
            self.difficulty = 'random.choice([self.col, self.row])(word)'
        elif difficulty == 2:
            self.difficulty = "random.choice([self.col, self.col_rev, self.row, self.row_rev])(word)"
        elif difficulty == 3:
            self.difficulty = "random.choice([self.col, self.row, self.diagup, self.diagdown])(word)"
        elif difficulty == 4:
            self.difficulty = "random.choice([self.col, self.col_rev, self.row, self.row_rev, self.diagup, self.diagup_rev, self.diagdown, self.diagdown_rev])(word)"

        self.puzzle_origin = []
        for i in range(self.height):
            self.puzzle_origin.append([])
            for j in range(self.width):
                self.puzzle_origin[i].append('0')
        print("퍼즐 만드는 중")
        words = [word[0] for word in self.word_image]
        for word in words:
            exec(self.difficulty)

        string_words = ''.join(words)
        from collections import Counter
        count_alpha = Counter(string_words)

        common_alph = ''
        for alph in count_alpha.most_common(5):
            common_alph += alph[0]

        data = ''
        if self.korean:
            f = open("random_words.txt", 'r')
            data = f.read()
            regex_f = r'[가-힣]+'
            search_target_f = data
            data = ''.join(list(set(re.findall(regex_f, search_target_f))))

        printed_words = ''
        puzzle = copy.deepcopy(self.puzzle_origin)
        for i in range(self.height):
            for j in range(self.width):
                if self.puzzle_origin[i][j] == "0":
                    fill_alph = random.choice(string.ascii_lowercase)
                    if self.korean:
                        fill_alph = random.choice(data)
                    #글자들 되도록 겹치지 않게 하기 위해서 많이 나오는 글자 한번쯤은 피할 수 있도록 한다.
                    if option == 0:
                        puzzle[i][j] = fill_alph
                    elif option == 1:
                        if fill_alph in common_alph:
                            fill_alph = random.choice(string.ascii_lowercase)
                            if self.korean:
                                fill_alph = random.choice(data)
                        puzzle[i][j] = fill_alph
                        printed_words += puzzle[i][j]
                    #글자가 겹치도록 하기 위해서 많이 나온 글자와 무작위 글자들 중에서 고르도록 한다.
                    elif option == 2:
                        common_alph_list = []
                        puzzle[i][j] = random.choice([fill_alph, random.choice(count_alpha.most_common(7))[0]])
                    printed_words += puzzle[i][j]



        # write to docx file
        # Write to docx to puzzle.docx
        document = Document()
        #changing the page margins
        sections = document.sections
        for section in sections:
            section.top_margin = Cm(1)
            section.bottom_margin = Cm(0.8)
            section.left_margin = Cm(2.3)
            section.right_margin = Cm(2.3)
        heading = 'Word Puzzle'
        if self.korean:
            heading = "낱말 찾기"
        head = document.add_heading(heading, 0)
        head.alignment = WD_ALIGN_PARAGRAPH.CENTER
        if os.path.exists('hwp_settings.json'):
            with open('hwp_settings.json') as f:
                data = json.load(f)
                para_belong = document.add_paragraph('{}학년 {}반 이름: _______'.format(data['grade'], data['class']))
        else:
            para_belong = document.add_paragraph('__학년 __반 이름: _______')
        para_belong.alignment = WD_ALIGN_PARAGRAPH.RIGHT

        puzzle_table = document.add_table(rows=self.height, cols=self.width, style='Table Grid')
        puzzle_table.alignment = WD_TABLE_ALIGNMENT.CENTER
        self.set_height = 7200 / self.height
        for i, row in enumerate(puzzle_table.rows):
            #######################세로 길이 정하기!
            # accessing row xml and setting tr height
            tr = row._tr
            trPr = tr.get_or_add_trPr()
            trHeight = OxmlElement('w:trHeight')
            trHeight.set(qn('w:val'), str(self.set_height))
            trHeight.set(qn('w:hRule'), "atLeast")
            trPr.append(trHeight)

            for j, cell in enumerate(row.cells):
                #####가로 길이 정하기!
                cell.width = Inches(5)
                if self.uppercase and not self.korean:
                    cell.text = puzzle[i][j].upper()
                else:
                    cell.text = puzzle[i][j]
                for paragraph in cell.paragraphs:
                    #####가운데 정렬!!
                    paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER
                    paragraph.style.font.bold = True
                #####상하 방향에서 가운데 정렬
                tc = cell._tc
                tcPr = tc.get_or_add_tcPr()
                tcVAlign = OxmlElement('w:vAlign')
                tcVAlign.set(qn('w:val'), "center")
                tcPr.append(tcVAlign)

        # 힌트 테이블 만들기
        # 사진이 들어가는 경우
        if self.pic_on:
            word_num = len(words)
            if word_num <= 15:
                size = 5
            elif word_num <= 21:
                size = (word_num+2)//3
            else:
                size = 7
            hint_table = document.add_table(rows = (len(words)+size-1)//size * 2, cols = size, style = 'Table Grid')
            hint_table.alignment = WD_TABLE_ALIGNMENT.CENTER

            for i, row in enumerate(hint_table.rows):
                #######################세로 길이 정하기!
                if i%2 == 0:
                    # accessing row xml and setting tr height
                    tr = row._tr
                    trPr = tr.get_or_add_trPr()
                    trHeight = OxmlElement('w:trHeight')
                    trHeight.set(qn('w:val'), '1000')
                    trHeight.set(qn('w:hRule'), "atLeast")
                    trPr.append(trHeight)
                elif i%2 == 1:
                    # accessing row xml and setting tr height
                    tr = row._tr
                    trPr = tr.get_or_add_trPr()
                    trHeight = OxmlElement('w:trHeight')
                    trHeight.set(qn('w:val'), '60')
                    trHeight.set(qn('w:hRule'), "atLeast")
                    trPr.append(trHeight)

                for j, cell in enumerate(row.cells):
                    index = i//2*size + j

                    #단어 수 만큼 반복하기
                    if index < len(words):
                        for paragraph in cell.paragraphs:
                            if i % 2 == 1:
                                # 초성 또는 scramble이 켜져 있는 경우
                                if self.chosung_scramable:
                                    word = words[index]
                                    if self.korean:
                                        cho_word = ''
                                        for chr in word:
                                            chosung_scramable = hgtk.letter.decompose(chr)[0]
                                            cho_word += chosung_scramable
                                        run = paragraph.add_run(cho_word)
                                    else:
                                        # 사진 있고 영어고 scramble인 경우
                                        spelling = [i for i in word]
                                        shuffle(spelling)
                                        scrambled_word = ''.join(spelling)
                                        if self.uppercase:
                                            run = paragraph.add_run(scrambled_word.upper())
                                        else:
                                            run = paragraph.add_run(scrambled_word)
                                else:
                                    if self.uppercase and not self.korean:
                                        run = paragraph.add_run(words[index].upper())
                                    else:
                                        run = paragraph.add_run(words[index])
                                font = run.font
                                font.name = 'Arial'
                                font.size = Pt(15)

                            elif i % 2 == 0:
                                try:
                                    run = paragraph.add_run()
                                    run.add_picture(self.word_image[index][1], width=cell.width *95/100,
                                                    height=cell.width)
                                except:
                                    paragraph.add_run("에러 발생. 다른 사진 선택해주세요.")


                            #####가운데 정렬!!
                            paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER
                            paragraph.style.font.bold = True
                    #####상하 방향에서 가운데 정렬
                    tc = cell._tc
                    tcPr = tc.get_or_add_tcPr()
                    tcVAlign = OxmlElement('w:vAlign')
                    tcVAlign.set(qn('w:val'), "center")
                    tcPr.append(tcVAlign)

        # 사진이 들어가지 않는 경우
        else:
            # 사진이 안 들어가고 영어인 경우
            if not self.korean:
                hint_table = document.add_table(rows=1, cols=1, style='Table Grid')
                hint_table.alignment = WD_TABLE_ALIGNMENT.CENTER
                hint_table_row = hint_table.rows[0]
                hint_tr = hint_table_row._tr
                hint_trPr = hint_tr.get_or_add_trPr()
                hint_trHeight = OxmlElement('w:trHeight')
                hint_trHeight.set(qn('w:val'), '1000')
                hint_trHeight.set(qn('w:hRule'), "atLeast")
                hint_trPr.append(hint_trHeight)
                hint_table_cell = hint_table_row.cells[0]
                hint = ''
                parenthesis = re.compile(r'(\s)?\(.*\)(\s)?')
                bracket = re.compile(r'(\s)?\[.*\](\s)?')
                for word in words:
                    print("사전에 찾는중... " + word)
                    req = requests.get('http://endic.naver.com/small_search.nhn?query=' + word)
                    # 국어사전은 'http://ko.dict.naver.com/small_search.nhn?query='
                    html = req.text
                    soup = BeautifulSoup(html, 'html.parser')
                    meanings = soup.select('span.fnt_k05')
                    if self.uppercase:
                        word = word.upper()
                    if self.chosung_scramable:
                        spelling = [i for i in word]
                        shuffle(spelling)
                        word = ''.join(spelling)
                    if meanings:
                        text = meanings[0].text
                        text = re.sub(parenthesis, '', text)
                        text = re.sub(bracket, '', text)
                        print(text)
                        hint += word + "({})".format(text) + ', '
                hint_table_cell.width = Inches(100)
                for paragraph in hint_table_cell.paragraphs:
                    paragraph.add_run(hint.strip(', '))
                    paragraph.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY
                tc = hint_table_cell._tc
                tcPr = tc.get_or_add_tcPr()
                tcVAlign = OxmlElement('w:vAlign')
                tcVAlign.set(qn('w:val'), "center")
                tcPr.append(tcVAlign)

            else:
                # 사진이 안 들어가고 한글인 경우
                if self.chosung_scramable:
                    hint_table = document.add_table(rows=1, cols=1, style='Table Grid')
                    hint_table.alignment = WD_TABLE_ALIGNMENT.CENTER
                    hint_table_row = hint_table.rows[0]
                    hint_tr = hint_table_row._tr
                    hint_trPr = hint_tr.get_or_add_trPr()
                    hint_trHeight = OxmlElement('w:trHeight')
                    hint_trHeight.set(qn('w:val'), '1000')
                    hint_trHeight.set(qn('w:hRule'), "atLeast")
                    hint_trPr.append(hint_trHeight)
                    hint_table_cell = hint_table_row.cells[0]
                    hint = ''
                    for word in words:
                        cho_word = ''
                        for chr in word:
                            chosung_scramable = hgtk.letter.decompose(chr)[0]
                            cho_word += chosung_scramable
                        hint += cho_word + ', '
                    hint_table_cell.width = Inches(100)
                    for paragraph in hint_table_cell.paragraphs:
                        paragraph.add_run(hint.strip(', '))
                        paragraph.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY
                    tc = hint_table_cell._tc
                    tcPr = tc.get_or_add_tcPr()
                    tcVAlign = OxmlElement('w:vAlign')
                    tcVAlign.set(qn('w:val'), "center")
                    tcPr.append(tcVAlign)
                else:
                    hint_table = document.add_table(rows=1, cols=1, style='Table Grid')
                    hint_table.alignment = WD_TABLE_ALIGNMENT.CENTER
                    hint_table_row = hint_table.rows[0]
                    hint_tr = hint_table_row._tr
                    hint_trPr = hint_tr.get_or_add_trPr()
                    hint_trHeight = OxmlElement('w:trHeight')
                    hint_trHeight.set(qn('w:val'), '1000')
                    hint_trHeight.set(qn('w:hRule'), "atLeast")
                    hint_trPr.append(hint_trHeight)
                    hint_table_cell = hint_table_row.cells[0]
                    hint = ''
                    for word in words:
                        hint += word + ', '
                    hint_table_cell.width = Inches(100)
                    for paragraph in hint_table_cell.paragraphs:
                        paragraph.add_run(hint.strip(', '))
                        paragraph.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY
                    tc = hint_table_cell._tc
                    tcPr = tc.get_or_add_tcPr()
                    tcVAlign = OxmlElement('w:vAlign')
                    tcVAlign.set(qn('w:val'), "center")
                    tcPr.append(tcVAlign)





        # 정답 파일 쓰기
        answ_doc = Document()
        answer_table = answ_doc.add_table(rows=self.height, cols=self.width, style='Table Grid')
        answer_table.alignment = WD_TABLE_ALIGNMENT.CENTER
        for i, row in enumerate(answer_table.rows):
            #######################세로 길이 정하기!
            # accessing row xml and setting tr height
            tr = row._tr
            trPr = tr.get_or_add_trPr()
            trHeight = OxmlElement('w:trHeight')
            trHeight.set(qn('w:val'), str(self.set_height))
            trHeight.set(qn('w:hRule'), "atLeast")
            trPr.append(trHeight)

            for j, cell in enumerate(row.cells):
                #####가로 길이 정하기!
                cell.width = Inches(8)
                cell.text = self.puzzle_origin[i][j]
                for paragraph in cell.paragraphs:
                    #####가운데 정렬!!
                    paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER
                    paragraph.style.font.bold = True
                    if cell.text == '0':
                        for run in paragraph.runs:
                            run.font.color.rgb = RGBColor(255, 255, 255)
                    else:
                        for run in paragraph.runs:
                            run.font.color.rgb = RGBColor(255, 0, 0)
                #####상하 방향에서 가운데 정렬
                tc = cell._tc
                tcPr = tc.get_or_add_tcPr()
                tcVAlign = OxmlElement('w:vAlign')
                tcVAlign.set(qn('w:val'), "center")
                tcPr.append(tcVAlign)

        answ_doc.save(str(self.desktop) + '\{}_정답.hwp'.format(filename))
        document.save(str(self.desktop) +'\{}.hwp'.format(filename))
        print("바탕화면에 puzzle.docx와 puzzle.hwp 로 저장")
예제 #24
0
def trans_pdf(file_name, path):
    t0 = time.time()
    cur_pdf = fitz.open(path)  # 待翻译的pdf
    new_pdf = fitz.open()  # 翻译完成后要写入的pdf
    new_docx = Document()  # 翻译完成后要写入的docx
    new_docx.styles['Normal'].font.name = u'宋体'  # 设置翻译完成后的字体
    new_docx.styles['Normal']._element.rPr.rFonts.set(qn('w:eastAsia'),
                                                      u'宋体')  # 设置翻译完成后的字体
    i = 0  # 定义页面数的递增
    bytes_array = 0
    try:
        for cur_page in cur_pdf:
            img_list = cur_page.getImageList()  # 获取当前页面的图片对象
            # print(cur_page.getFontList()) # 页面使用的字体列表
            # print(img_list)
            imgcount = 0
            for img in img_list:  # 获取当前页面的图像列表
                pix_temp1 = fitz.Pixmap(cur_pdf, img[0])
                if img[1]:
                    pix_temp2 = fitz.Pixmap(cur_pdf, img[1])
                    pix_temp = fitz.Pixmap(pix_temp1)
                    pix_temp.setAlpha(pix_temp2.samples)
                else:
                    pix_temp = pix_temp1
                imgcount += 1
                new_name = "图片{}.png".format(imgcount)  # 生成图片的名称
                pix_temp.writeImage(
                    os.path.join(settings.BASE_DIR, 'trans', 'output_file',
                                 new_name))
                # bytes_array = pix_temp.getImageData('png')#可以不输出图片再写入新的pdf,通过byte
                # print(pix_temp.getImageData('png'))
                pix_temp = None  # 释放资源
            print(
                '当前正在翻译翻译第{}页...'.format(int(str(cur_page).split(' ')[1]) + 1))
            # 读取输入页面的blocks
            blks = cur_page.getTextBlocks(flags=4)
            # 创建一个新的页面与之前的页面相同大小
            new_page = new_pdf.newPage(-1,
                                       width=cur_page.MediaBoxSize[0],
                                       height=cur_page.MediaBoxSize[1])
            img = new_page.newShape()  # prepare /Contents object
            disp = fitz.Rect(cur_page.CropBoxPosition,
                             cur_page.CropBoxPosition)
            croprect = cur_page.rect + disp
            # img.drawRect(croprect)#画出整个页面的矩形
            # img.finish(color=gray, fill=gray)#填充颜色
            begin = (0, 0, 0, 0)  # 记录初始值
            end = (0, 0, 0, 0)  # 记录终结值
            flag = 0  # 记录当前的循
            reference_flag = 0  # 判断是否在参考文献之后
            blks.append((1, 2, 3, 6))
            content = ""
            imgcount = 0
            fonts = 9
            for num in range(len(blks)):
                # 如果是本页面最后一个块,直接结束,因为最后一个是方便计算自己添加的。
                if num == len(blks) - 1:
                    break
                # 如果这个块里放的是图像.
                if blks[num][-1] == 1:
                    print('图像:::', blks[num][4])
                    imgcount += 1
                    # 图片要放置位置的坐标
                    img_r = blks[num][:4]
                    # 当前页面第几个图片的位置
                    image_path = os.path.join(settings.BASE_DIR, 'trans',
                                              'output_file',
                                              '图片{}.png'.format(imgcount))
                    # 输入流
                    img = open(image_path, "rb").read()
                    # 输入到新的pdf页面对应位置
                    new_page.insertImage(img_r,
                                         stream=img,
                                         keep_proportion=True)
                    # 设置图片保存的宽度
                    new_docx.add_picture(image_path, width=Inches(3))
                    # 输入到新的pdf之后就移除
                    os.remove(image_path)
                    continue

                # 设置默认字体大小以及位置
                if i == 0:  # 当前是第一页的话
                    # 一般论文前面的标题,作者,机构名等要居中
                    if num == 0 or num == 1:
                        fonts = 15
                        text_pos = fitz.TEXT_ALIGN_CENTER
                    elif num == 2:
                        fonts = 10
                        text_pos = fitz.TEXT_ALIGN_CENTER
                    elif num == 3:
                        fonts = 10
                        text_pos = fitz.TEXT_ALIGN_CENTER
                    # 设置文字在当前矩阵中的位置靠左排列
                    else:
                        fonts = 10
                        text_pos = fitz.TEXT_ALIGN_LEFT
                # 设置文字在当前矩阵中的位置靠左排列
                else:
                    fonts = 10
                    text_pos = fitz.TEXT_ALIGN_LEFT
                # 目的为了记录起始块坐标
                if num == 0:
                    begin = blks[0][:4]
                    content = blks[0][4].replace("\n", " ")
                # 矩形块,b[0]b[1]为左上角的坐标,b[2]b[3]为右下角的坐标
                r = fitz.Rect(blks[num][:4])
                # 如果不是倒数第一个块,则进入此循环
                if num < len(blks) - 1:
                    # 两个块y轴距离很近的话,这里以1.0为界,这里判断当前数的右下角的坐标y值
                    if (abs(blks[num + 1][1] - blks[num][3]) <= 1.0
                            and abs(blks[num + 1][1] - blks[num][3]) >= 0):
                        # 当前块在参考文献之后
                        if reference_flag == 1:
                            trans_pragraph = blks[num][4].replace("\n", " ")
                            res = translate_func.google_translate(
                                trans_pragraph).replace(' ', '')
                            new_page.insertTextbox(
                                r,
                                res,
                                fontname="song",
                                fontfile=os.path.join(
                                    settings.BASE_DIR,
                                    'trans/static/fonts/SimSun.ttf'),
                                fontsize=7,
                                align=text_pos)  #
                        # 其它情况
                        else:
                            flag = 1  #
                            # 记录最后的矩形坐标,目的为了取出最后的右下角坐标点
                            end = blks[num + 1][:4]
                            content += blks[num + 1][4].replace("\n", " ")
                            # print('content::',content)

                    # 两个块y轴距离远的的时候
                    else:
                        if flag == 1:
                            # img.drawRect(fitz.Rect(end[0],begin[1],end[2],end[3]))
                            res = translate_func.google_translate(
                                content).replace(' ', '')  # 翻译结果去掉汉字中的空格
                            new_docx.add_paragraph(res)  # 添加到新的docx文档中
                            # print('content:',content)
                            # print(res)
                            # fitz.Rect(end[0],begin[1],end[2],end[3])为新扩展的矩形框坐标
                            if begin[2] > end[2]:  # 如果起始点的右下角x坐标小于结束点的右下角x坐标
                                new_page.insertTextbox(
                                    fitz.Rect(end[0], begin[1], begin[2],
                                              end[3]),
                                    res,
                                    fontname="song",
                                    fontfile=os.path.join(
                                        settings.BASE_DIR,
                                        'trans/static/fonts/SimSun.ttf'),
                                    fontsize=fonts,
                                    align=text_pos)
                            else:
                                new_page.insertTextbox(
                                    fitz.Rect(end[0], begin[1], end[2],
                                              end[3]),
                                    res,
                                    fontname="song",
                                    fontfile=os.path.join(
                                        settings.BASE_DIR,
                                        'trans/static/fonts/SimSun.ttf'),
                                    fontsize=fonts,
                                    align=text_pos)
                            flag = 0
                        else:
                            # img.drawRect(r)
                            trans_pragraph = blks[num][4].replace(
                                "\n", " ")  # 将待翻译的句子换行换成空格
                            if is_figure(trans_pragraph.replace(
                                    ' ', '')):  # 将该块的判断是否是图片标注
                                res = translate_func.google_translate(
                                    trans_pragraph).replace(' ',
                                                            '')  # 翻译结果去掉汉字中的空格
                                new_page.insertTextbox(
                                    r,
                                    res,
                                    fontname="song",
                                    fontfile=os.path.join(
                                        settings.BASE_DIR,
                                        'trans/static/fonts/SimSun.ttf'),
                                    fontsize=7,
                                    align=fitz.TEXT_ALIGN_CENTER)
                            # 标记在这里之后的都是参考文献
                            elif is_reference(trans_pragraph.replace(' ', '')):
                                reference_flag = 1
                                new_page.insertTextbox(
                                    r,
                                    '参考文献',
                                    fontname="song",
                                    fontfile=os.path.join(
                                        settings.BASE_DIR,
                                        'trans/static/fonts/SimSun.ttf'),
                                    fontsize=fonts,
                                    align=text_pos)
                            else:
                                # 翻译结果去掉汉字中的空格
                                res = translate_func.google_translate(
                                    trans_pragraph).replace(' ', '')
                                # 添加到新的docx文档中
                                new_docx.add_paragraph(res)
                                if reference_flag == 1:
                                    new_page.insertTextbox(
                                        r,
                                        res,
                                        fontname="song",
                                        fontfile=os.path.join(
                                            settings.BASE_DIR,
                                            'trans/static/fonts/SimSun.ttf'),
                                        fontsize=7,
                                        align=text_pos)  #
                                else:

                                    new_page.insertTextbox(
                                        r,
                                        res,
                                        fontname="song",
                                        fontfile=os.path.join(
                                            settings.BASE_DIR,
                                            'trans/static/fonts/SimSun.ttf'),
                                        fontsize=fonts,
                                        align=text_pos)  #
                        # 记录起始矩形坐标
                        begin = blks[num + 1][:4]
                        try:
                            content = blks[num + 1][4].replace("\n", " ")
                            # print('content:::',content)
                        except:
                            pass
                            #print('记录content失败!')
                        # img.finish(width=0.3)
                        # img.commit()
            i += 1
    # 如果整个过程出现异常,防止翻译工作丢失,直接保存到文件中结束翻译。
    except Exception as error:
        print('翻译过程出现异常如下:\n', error)
        # 翻译后的pdf保存路径
        # new_pdf_name = os.path.join(settings.BASE_DIR, 'trans', 'output_file', 'translated_' + file_name)
        # 翻译后的docx保存路径
        new_docx_name = os.path.join(settings.BASE_DIR, 'trans', 'output_file',
                                     'translated_' + file_name[:-4] + '.docx')
        new_docx.save(new_docx_name)
        # new_pdf.save(new_pdf_name, garbage=4, deflate=True, clean=True)
        return 'fail'
    # 文件保存
    # 翻译后的pdf保存路径
    new_pdf_name = os.path.join(settings.BASE_DIR, 'trans', 'output_file',
                                'translated_' + file_name)
    # 翻译后的docx保存路径
    new_docx_name = os.path.join(settings.BASE_DIR, 'trans', 'output_file',
                                 'translated_' + file_name[:-4] + '.docx')
    new_docx.save(new_docx_name)
    new_pdf.save(new_pdf_name, garbage=4, deflate=True, clean=True)
    t1 = time.time()
    print("Total translation time: %g sec" % (t1 - t0))
    return 'success'
예제 #25
0
 def addPicture(self, picturePath):
     pictureFileName = picturePath + '_pl4.png'
     self.__document.add_picture(pictureFileName, width=Inches(3))
예제 #26
0
document = Document()

document.add_heading('Document Title', 0)

p = document.add_paragraph('A plain paragraph having some ')
p.add_run('bold').bold = True
p.add_run(' and some ')
p.add_run('italic.').italic = True

document.add_heading('Heading, level 1', level=1)
document.add_paragraph('Intense quote', style='Intense Quote')

document.add_paragraph('first item in unordered list', style='List Bullet')
document.add_paragraph('first item in ordered list', style='List Number')

document.add_picture('Test_gps.jpg', width=Inches(1.25))

records = ((3, '101', 'Spam'), (7, '422', 'Eggs'),
           (4, '631', 'Spam, spam, eggs, and spam'))
rgbColor = RGBColor(0, 255, 0)
table = document.add_table(rows=1, cols=3)
hdr_cells = table.rows[0].cells
hdr_cells[0].text = 'Qty'
hdr_cells[1].text = 'Id'
hdr_cells[2].text = 'Desc'
for qty, id, desc in records:
    row_cells = table.add_row().cells
    row_cells[0].text = str(qty)
    row_cells[1].text = id
    row_cells[2].text = desc
    tmp = "0,255,0"
예제 #27
0
text = re.sub(r'@\S+', '', text, flags=re.MULTILINE)
print(text)
stopwords = set(STOPWORDS)
stopwords.update([
    "drink", "now", "wine", "flavor", "flavors", "RT", "Rashmika", "Mandanna",
    "cruz", "know"
])

# mask = np.array(Image.open(requests.get('http://www.clker.com/cliparts/O/i/x/Y/q/P/yellow-house-hi.png', stream=True).raw))
mask = np.array(Image.open('rash1.png'))

wordcloud = WordCloud(stopwords=stopwords,
                      background_color="white",
                      max_words=100,
                      mask=mask).generate(text)

image_colors = ImageColorGenerator(mask)
plt.figure(figsize=[7, 7])
plt.imshow(wordcloud.recolor(color_func=image_colors),
           interpolation="bilinear")
plt.axis("off")

plt.title('Summarization of Rashmika Tweets.')
plt.savefig('Rush.png')
document.add_picture('Rush.png', width=Inches(5))
document.save("Report")
wordcloud.to_file("Rush.png")
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis("off")
api.update_with_media(filename='Rush.png', status='Rashmika Tweet summary')
plt.show()
예제 #28
0
def take_picture(file):
	read()
	os.system('sudo fswebcam -r 640x420 test.jpg -S 8')
	doc=Document(file)
	doc.add_picture('/home/pi/test.jpg',width=Inches(1.25))
	doc.save(file)
def main(param):
    docx_name, chessboard_cm, width_cm, height_cm = param  # 获取参数
    chessboard_pixel = chessboard_cm * scale  # 棋盘格单元对应像素
    width = round(width_cm / chessboard_cm)  # 棋盘格角点列数
    height = round(height_cm / chessboard_cm)  # 棋盘格角点行数
    width_pix = round(width_cm * scale)  # 棋盘格列像素
    height_pix = round(height_cm * scale)  # 棋盘格行像素

    size = width_cm / height_cm  # 棋盘格长宽比例(用于最后的裁切)

    image = np.zeros((height_pix, width_pix, 3), dtype=np.uint8)  # 生成对应像素图片
    image.fill(255)  # 填充白色
    color = (255, 255, 255)
    fill_color = 0
    for j in range(0, height + 1):  # 绘制棋盘
        y = round(j * chessboard_pixel)
        for i in range(0, width + 1):
            x0 = round(i * chessboard_pixel)
            y0 = y
            rect_start = (x0, y0)

            x1 = round(x0 + chessboard_pixel)
            y1 = round(y0 + chessboard_pixel)
            rect_end = (x1, y1)
            cv2.rectangle(image, rect_start, rect_end, color, 1, 0)
            image[y0:y1, x0:x1] = fill_color
            if width % 2:
                if i != width:
                    fill_color = (0 if (fill_color == 255) else 255)
            else:
                if i != width + 1:
                    fill_color = (0 if (fill_color == 255) else 255)
    bottom = round(width_pix / size)  # 获取按cm比例对应的行像素
    if bottom < height_pix:
        image = image[0:bottom, :, :]  # 裁切

    # 创建显示窗口
    win_name = "chessboard"
    # cv.namedWindow(win_name, cv.WINDOW_NORMAL)
    cv2.imwrite(win_name + ".bmp", image)
    # cv.imshow(win_name, image)
    # cv.waitKey()

    doc = Document()  # 以默认模板建立文档对象
    distance = Inches(0)
    sec = doc.sections[0]  # 页边距0英寸
    sec.left_margin = distance  # 以下依次设置左、右、上、下页面边距
    sec.right_margin = distance
    sec.top_margin = distance
    sec.bottom_margin = distance

    sec.page_width = Cm(width_cm)  # 设置页面宽度
    sec.page_height = Cm(height_cm)  # 设置页面高度

    img_encode = cv2.imencode('.bmp', image)[1]  # 对opencv图片进行编码
    str_encode = img_encode.tostring()
    cc = io.BytesIO(str_encode)
    # img = doc.add_picture(cc, Cm(42.01))
    doc.add_picture(cc)  # 插入图片至word
    # doc.add_picture(win_name + ".bmp")
    doc.save(docx_name)  # 保存图像
예제 #30
0
파일: OtchetW.py 프로젝트: EchEdward/Vive
def Word(inf, lbsz, f, f2, fname, name_vl, NS, var, grop, zpps, per_name,
         D_file, Trig, tablepo):
    # Создаём объект документа
    if Trig:  #'template_word/default.docx'
        document = D_file
    else:
        document = Document()

    # Наследуем стиль и изменяем его
    style = document.styles['Normal']  # Берём стиль Нормальный

    f0 = style.font  # Переменная для изменения параметров стиля
    f0.name = 'Arial'  # Шрифт
    f0.size = Pt(12)  # Размер шрифта

    pf = style.paragraph_format
    pf.line_spacing = Pt(0)  # Междустрочный интервал
    pf.space_after = Pt(0)  # Интервал после абзаца

    # Задаём свойство полей
    sections = document.sections
    s = sections[0]
    s.left_margin = Mm(30)
    s.right_margin = Mm(15)
    s.top_margin = Mm(20)
    s.bottom_margin = Mm(20)
    s.page_height = Mm(297)
    s.page_width = Mm(210)

    if tablepo == 'Выводить таблицы и эпюры':
        tb1 = True
        tb2 = True
    elif tablepo == 'Выводить таблицы':
        tb1 = True
        tb2 = False
    elif tablepo == 'Выводить эпюры':
        tb1 = False
        tb2 = True

    # Функция выравнивания содержимого таблицы по вертикали
    def set_cell_vertical_alignment(cell, align="center"):
        try:
            tc = cell._tc
            tcPr = tc.get_or_add_tcPr()
            tcValign = OxmlElement('w:vAlign')
            tcValign.set(qn('w:val'), align)
            tcPr.append(tcValign)
            return True
        except:
            #traceback.print_exc()
            return False

    p0 = ['', '', '', '']
    sv = '.' + var if var != '' else ''
    if tb1:

        # Зоголовок
        if not Trig:
            document._body.clear_content(
            )  # Удаляет все параграфы(Обезаетльно протом нужно чтото добавить)
        p0[0] = document.add_paragraph()
        p0[0].add_run('РЕЖИМ ЗАЗЕМЛЕНИЯ').bold = True
        pt_f1 = p0[0].paragraph_format
        pt_f1.alignment = WD_ALIGN_PARAGRAPH.CENTER
        pt_f1.space_after = Pt(2)

        p0[1] = document.add_paragraph()
        p0[1].add_run(name_vl).bold = True
        pt_f1 = p0[1].paragraph_format
        pt_f1.alignment = WD_ALIGN_PARAGRAPH.CENTER
        pt_f1.space_after = Pt(2)

        p0[2] = document.add_paragraph()
        p0[2].add_run('Безопасность производства работ на участках ВЛ '\
                    +'обеспечивается при следующих Схемах заземления ВЛ:').bold = True
        pt_f1 = p0[2].paragraph_format
        pt_f1.alignment = WD_ALIGN_PARAGRAPH.CENTER
        pt_f1.space_after = Pt(2)

        p0[3] = document.add_paragraph()

        p0[3].add_run('СХЕМА ' + NS + sv + ' ЗАЗЕМЛЕНИЯ').bold = True
        pt_f1 = p0[3].paragraph_format
        pt_f1.alignment = WD_ALIGN_PARAGRAPH.CENTER
        pt_f1.space_after = Pt(2)

    # Информация о заземлении
    s1 = []
    s2 = []
    re_op_key = list(per_name.keys())
    c1 = False
    c2 = False
    v = []
    inf1 = []
    for h in range(len(inf)):

        ss1, ss2 = inf[h][1].split(Razd_simv, 1)
        ss1 = (ss1.strip()).replace(" ", "\u00A0")
        ss2 = (ss2.strip()).replace(" ", "\u00A0")
        inf1.append(ss1 + " " + Razd_simv + " " + ss2)

        if inf[h][0] == 1:
            if inf[h][5]:
                s1.append(ss1)
                c1 = True
            else:
                s2.append(ss1)
                c2 = True

            if inf[h][6]:
                s1.append(ss2)
                c1 = True
            else:
                s2.append(ss2)
                c2 = True
        elif inf[h][0] == 2:
            if inf[h][5]:
                s1.append(ss1)
                c1 = True
            else:
                s2.append(ss1)
                c2 = True
        elif inf[h][0] == 3:
            if inf[h][6]:
                s1.append(ss2)
                c1 = True
            else:
                s2.append(ss2)
                c2 = True
        #v.append(i)
        make_zy_list = []
        for j in range(len(lbsz[h])):
            if lbsz[h][j][0] in per_name[re_op_key[h]]:
                new_op = per_name[re_op_key[h]][lbsz[h][j][0]]
            else:
                new_op = lbsz[h][j][0]
            c1 = True
            #s1.append('Опора №'+str(new_op)+' '+('('+lbsz[h][j][1]+' '+lbsz[h][j][2].replace(",",".")+')').replace(" ","\u00A0")+' на участке '+inf1[h])
            make_zy_list.append([
                new_op,
                ('(' + lbsz[h][j][1] + ' ' + lbsz[h][j][2].replace(",", ".") +
                 ')').replace(" ", "\u00A0"), inf1[h]
            ])

        vetvi_dict = {}
        for j in range(len(make_zy_list)):
            if make_zy_list[j][2] not in vetvi_dict:
                vetvi_dict[make_zy_list[j][2]] = [j]
            else:
                vetvi_dict[make_zy_list[j][2]].append(j)

        #if len(inf)==1:

        for key_name in vetvi_dict:
            for j in vetvi_dict[key_name]:
                s1.append('Опора №' + str(make_zy_list[j][0]) + ' ' +
                          make_zy_list[j][1])

            if len(inf) > 1:
                s1[len(s1) - 1] += ' на участке ' + key_name

    ign_f = set()
    for i in range(len(inf)):
        if grop:
            for j in range(len(f[i])):
                if inf[i][0] == 1 and abs(inf[i][2] - inf[i][3]) >= 3:
                    if inf[i][2] == f[i][j][0][0]:
                        if f[i][j][0][1] == inf[i][2] + 1 or f[i][j][0][
                                1] == inf[i][2] - 1:
                            ign_f.add((i, j))
                        elif inf[i][2] < inf[i][3]:
                            f[i][j][0][0] = inf[i][2] + 1
                        elif inf[i][2] > inf[i][3]:
                            f[i][j][0][0] = inf[i][2] - 1
                    if inf[i][3] == f[i][j][0][1]:
                        if f[i][j][0][0] == inf[i][3] - 1 or f[i][j][0][
                                0] == inf[i][3] + 1:
                            ign_f.add((i, j))
                        elif inf[i][2] < inf[i][3]:
                            f[i][j][0][1] = inf[i][3] - 1
                        elif inf[i][2] > inf[i][3]:
                            f[i][j][0][1] = inf[i][3] + 1
                if inf[i][0] == 2 and abs(inf[i][2] - inf[i][3]) >= 2:
                    if inf[i][2] == f[i][j][0][0]:
                        if f[i][j][0][1] == inf[i][2] + 1 or f[i][j][0][
                                1] == inf[i][2] - 1:
                            f[i][j] = None
                        elif inf[i][2] < inf[i][3]:
                            f[i][j][0][0] = inf[i][2] + 1
                        elif inf[i][2] > inf[i][3]:
                            f[i][j][0][0] = inf[i][2] - 1
                if inf[i][0] == 3 and abs(inf[i][2] - inf[i][3]) >= 2:
                    if inf[i][3] == f[i][j][0][1]:
                        if f[i][j][0][0] == inf[i][3] - 1 or f[i][j][0][
                                0] == inf[i][3] + 1:
                            f[i][j] = None
                        elif inf[i][2] < inf[i][3]:
                            f[i][j][0][1] = inf[i][3] - 1
                        elif inf[i][2] > inf[i][3]:
                            f[i][j][0][1] = inf[i][3] + 1

    # Цикл по ветвям
    p1 = []
    if tb1:
        for i in range(len(inf)):
            p1.append(['', '', '', '', ''])

            # Имя ветви
            p1[i][0] = document.add_paragraph()
            p1[i][0].add_run(inf1[i]).bold = True
            pt_f = p1[i][0].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            if c1:
                p1[i][1] = document.add_paragraph()
                pt_f = p1[i][1].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
                p1[i][1].add_run('ВЛ заземлена: ').bold = True
                for j in range(len(s1)):
                    if j == len(s1) - 1:
                        p1[i][1].add_run(s1[j] + '.')
                    else:
                        p1[i][1].add_run(s1[j] + ', ')
            if c2:
                p1[i][2] = document.add_paragraph()
                pt_f = p1[i][2].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
                p1[i][2].add_run('ВЛ разземлена: ').bold = True
                for j in range(len(s2)):
                    if j == len(s2) - 1:
                        p1[i][2].add_run(s2[j] + '.')
                    else:
                        p1[i][2].add_run(s2[j] + ', ')

            # Картинка схемы заземления
            p1[i][3] = document.add_picture('result_schemes/' + str(i) +
                                            '.jpg',
                                            width=Inches(6.5))
            #last_paragraph = document.paragraphs[-1]
            #last_paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER

            # Создаём шапку таблицы
            p1[i][4] = document.add_table(
                rows=1, cols=2,
                style='Table Grid')  # Таблица с размерами и стилем

            p_t = p1[i][4].style.paragraph_format
            p_t.keep_with_next = True  # Если невмещается таблица на текущую страницу, переносит её на ноыую

            row_1 = p1[i][4].rows[0]  # Обращаемся к строке заголовка

            row_1.cells[0].text = 'Участки ВЛ'  # Присваиваем текст
            r = row_1.cells[0].paragraphs[0].runs[0]  # Делаем его жирным
            row_1.cells[0].paragraphs[0].alignment = WD_ALIGN_PARAGRAPH.LEFT
            set_cell_vertical_alignment(
                row_1.cells[0],
                align="center")  # Выравнивание содержимого по вертикали
            r.font.bold = True

            row_1.cells[1].text = 'Разрешение на выполнение работ'
            row_1.cells[1].paragraphs[0].alignment = WD_ALIGN_PARAGRAPH.LEFT
            set_cell_vertical_alignment(
                row_1.cells[1],
                align="center")  # Выравнивание содержимого по вертикали
            r = row_1.cells[1].paragraphs[0].runs[0]
            r.font.bold = True

            ss1, ss2 = inf[i][1].split(Razd_simv, 1)
            ss1 = (ss1.strip()).replace(" ", "\u00A0")
            ss2 = (ss2.strip()).replace(" ", "\u00A0")

            # ПС слева (если есть)
            if inf[i][0] == 1 or inf[i][0] == 2:
                row_cells = p1[i][4].add_row(
                ).cells  # Добавляем в таблицу новую строку
                row_cells[0].text = ss1
                set_cell_vertical_alignment(
                    row_cells[0],
                    align="center")  # Выравнивание содержимого по вертикали
                if f2[i][inf[i][2]] or (zpps == True and inf[i][5] == False and
                                        (inf[h][0] == 1 or inf[h][0] == 2)):
                    row_cells[1].text = 'Запрещено'
                    r = row_cells[1].paragraphs[0].runs[0]
                    r.font.bold = True
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали
                else:
                    row_cells[1].text = 'Разрешено'
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали

            # Участки ВЛ

            for j in range(len(f[i])):
                if (i, j) in ign_f: continue

                row_cells = p1[i][4].add_row(
                ).cells  # Добавляем в таблицу новую строку

                if f[i][j][0][0] in per_name[re_op_key[i]]:
                    new_op1 = per_name[re_op_key[i]][f[i][j][0][0]]
                else:
                    new_op1 = f[i][j][0][0]
                if f[i][j][0][1] in per_name[re_op_key[i]]:
                    new_op2 = per_name[re_op_key[i]][f[i][j][0][1]]
                else:
                    new_op2 = f[i][j][0][1]
                row_cells[0].text = 'Опоры № ' + str(new_op1) + '-' + str(
                    new_op2)
                set_cell_vertical_alignment(
                    row_cells[0],
                    align="center")  # Выравнивание содержимого по вертикали
                if f[i][j][1]:
                    row_cells[1].text = 'Запрещено'
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали
                    r = row_cells[1].paragraphs[0].runs[0]
                    r.font.bold = True
                else:
                    row_cells[1].text = 'Разрешено'
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали
            # ПС справа (если есть)
            if inf[i][0] == 1 or inf[i][0] == 3:
                row_cells = p1[i][4].add_row(
                ).cells  # Добавляем в таблицу новую строку
                row_cells[0].text = ss2
                set_cell_vertical_alignment(
                    row_cells[0],
                    align="center")  # Выравнивание содержимого по вертикали
                if f2[i][inf[i][3]] or (zpps == True and inf[i][6] == False and
                                        (inf[h][0] == 1 or inf[h][0] == 3)):
                    row_cells[1].text = 'Запрещено'
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали
                    r = row_cells[1].paragraphs[0].runs[0]
                    r.font.bold = True
                else:
                    row_cells[1].text = 'Разрешено'
                    set_cell_vertical_alignment(
                        row_cells[1], align="center"
                    )  # Выравнивание содержимого по вертикали
            document.add_paragraph()

        if tb2: document.add_page_break()  # Разрыв страницы

    # Эпюры
    if tb2:
        # Информация о заземлении
        s1 = []
        s3 = []
        s2 = []

        c1 = False
        c2 = False
        c3 = False

        for i in range(len(inf)):
            ss1, ss2 = inf[i][1].split(Razd_simv, 1)
            ss1 = (ss1.strip()).replace(" ", "\u00A0")
            ss2 = (ss2.strip()).replace(" ", "\u00A0")

            if inf[i][0] == 1:
                if inf[i][5]:
                    s1.append(ss1)
                    c1 = True
                else:
                    s2.append(ss1)
                    c2 = True

                if inf[i][6]:
                    s1.append(ss2)
                    c1 = True
                else:
                    s2.append(ss2)
                    c2 = True
            elif inf[i][0] == 2:
                if inf[i][5]:
                    s1.append(ss1)
                    c1 = True
                else:
                    s2.append(ss1)
                    c2 = True
            elif inf[i][0] == 3:
                if inf[i][6]:
                    s1.append(ss2)
                    c1 = True
                else:
                    s2.append(ss2)
                    c2 = True

            make_zy_list = []

            for j in range(len(lbsz[i])):
                if lbsz[i][j][0] in per_name[re_op_key[i]]:
                    new_op = per_name[re_op_key[i]][lbsz[i][j][0]]
                else:
                    new_op = lbsz[i][j][0]
                c3 = True
                #s3.append('№'+str(new_op)+' '+('('+lbsz[i][j][1]+' '+lbsz[i][j][2].replace(",",".")+')').replace(" ","\u00A0")+' на участке '+inf1[i])

                make_zy_list.append([
                    new_op,
                    ('(' + lbsz[i][j][1] + ' ' +
                     lbsz[i][j][2].replace(",", ".") + ')').replace(
                         " ", "\u00A0"), inf1[i]
                ])

            vetvi_dict = {}
            for j in range(len(make_zy_list)):
                if make_zy_list[j][2] not in vetvi_dict:
                    vetvi_dict[make_zy_list[j][2]] = [j]
                else:
                    vetvi_dict[make_zy_list[j][2]].append(j)

            #if len(inf)==1:

            for key_name in vetvi_dict:
                for j in vetvi_dict[key_name]:
                    s3.append('№' + str(make_zy_list[j][0]) + ' ' +
                              make_zy_list[j][1])

                if len(inf) > 1:
                    s3[len(s3) - 1] += ' на участке ' + key_name

        # Цикл по ветвям
        p = []
        for i in range(len(inf)):
            p.append([
                '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
                '', ''
            ])

            # Имя ВЛ
            p[i][15] = document.add_paragraph()
            p[i][15].add_run(name_vl).bold = True
            pt_f = p[i][15].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            # Заголовок
            p[i][0] = document.add_paragraph()

            if len(inf) == 1:
                p[i][0].add_run('СХЕМА ' + NS + sv + ' ЗАЗЕМЛЕНИЯ').bold = True
            else:
                p[i][0].add_run('СХЕМА ' + NS + sv + ' ЗАЗЕМЛЕНИЯ').bold = True
                #p[i][0].add_run('СХЕМА '+NS+sv+'.'+str(i+1)+' ЗАЗЕМЛЕНИЯ').bold = True

            pt_f = p[i][0].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            # Рабочий участок
            p[i][1] = document.add_paragraph()
            p[i][1].add_run('РАБОЧИЙ УЧАСТОК').bold = True
            pt_f = p[i][1].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            # ПС и опоры на которых можно работать
            p[i][2] = document.add_paragraph('Опоры № ')

            ss1, ss2 = inf[i][1].split(Razd_simv, 1)
            ss1 = (ss1.strip()).replace(" ", "\u00A0")
            ss2 = (ss2.strip()).replace(" ", "\u00A0")

            s4 = []
            s5 = []
            s6 = []
            s7 = []
            c4 = False
            c5 = False
            c6 = False
            c7 = False

            # Участки ВЛ
            for j in range(len(f[i])):
                if (i, j) in ign_f: continue
                if f[i][j][0][0] in per_name[re_op_key[i]]:
                    new_op1 = per_name[re_op_key[i]][f[i][j][0][0]]
                else:
                    new_op1 = f[i][j][0][0]
                if f[i][j][0][1] in per_name[re_op_key[i]]:
                    new_op2 = per_name[re_op_key[i]][f[i][j][0][1]]
                else:
                    new_op2 = f[i][j][0][1]

                if not f[i][j][1]:
                    s4.append(str(new_op1) + '-' + str(new_op2))
                    c4 = True
                elif f[i][j][1]:
                    s6.append(str(new_op1) + '-' + str(new_op2))
                    c6 = True

            # ПС слева (если есть)
            if inf[i][0] == 1 or inf[i][0] == 2:
                if f2[i][inf[i][2]] or (zpps == True and inf[i][5] == False and
                                        (inf[i][0] == 1 or inf[i][0] == 2)):
                    s7.append(ss1)
                    c7 = True
                else:
                    s5.append(ss1)
                    c5 = True

            # ПС справа (если есть)
            if inf[i][0] == 1 or inf[i][0] == 3:
                if f2[i][inf[i][3]] or (zpps == True and inf[i][6] == False and
                                        (inf[i][0] == 1 or inf[i][0] == 3)):
                    s7.append(ss2)
                    c7 = True
                else:
                    s5.append(ss2)
                    c5 = True

            if c4:
                for j in range(len(s4)):
                    if j == len(s4) - 1 and c5:
                        p[i][2].add_run(s4[j] + ', ')
                    elif j == len(s4) - 1 and not c5:
                        p[i][2].add_run(s4[j])
                    else:
                        p[i][2].add_run(s4[j] + ', ')

            if c5:
                for j in range(len(s5)):
                    if j == len(s5) - 1:
                        p[i][2].add_run(s5[j])
                    else:
                        p[i][2].add_run(s5[j] + ', ')

            pt_f = p[i][2].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            # Схема заземления вл
            p[i][3] = document.add_paragraph()
            p[i][3].add_run('СХЕМА ЗАЗЕМЛЕНИЯ ВЛ').bold = True
            pt_f = p[i][3].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER

            # Картинка схемы заземления
            p[i][4] = document.add_picture('result_schemes/' + str(i) + '.jpg',
                                           width=Inches(6.5))
            #last_paragraph = document.paragraphs[-1]
            #last_paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER

            # Карта заземления
            p[i][5] = document.add_paragraph()
            p[i][5].add_run('КАРТА ЗАЗЕМЛЕНИЯ').bold = True
            pt_f = p[i][5].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)

            k = 1
            # Пункт 1 (Инфа о заземлении)
            p[i][6] = document.add_paragraph('1. ')
            pt_f = p[i][6].paragraph_format
            pt_f.first_line_indent = Mm(12.5)
            pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
            if c1:
                p[i][6].add_run('Заземлить ВЛ на ПЗ на ')
                for j in range(len(s1)):
                    if j == len(s1) - 1:
                        p[i][6].add_run(s1[j] + '. ')
                    else:
                        p[i][6].add_run(s1[j] + ', ')
                k = 2
            if c3:
                p[i][6].add_run('Заземлить ВЛ на опор%s ' %
                                ('e' if len(s3) == 1 else 'ах'))
                for j in range(len(s3)):
                    if j == len(s3) - 1:
                        p[i][6].add_run(s3[j] + '. ')
                    else:
                        p[i][6].add_run(s3[j] + ', ')
                k = 2
            if c2:
                p[i][6].add_run('Не заземлять ВЛ на ')
                for j in range(len(s2)):
                    if j == len(s2) - 1:
                        p[i][6].add_run(s2[j] + '. ')
                    else:
                        p[i][6].add_run(s2[j] + ', ')
                k = 2

            # Пункт 2 (Заземление ЛЗ на рабочих участках)
            if c4:
                p[i][7] = document.add_paragraph(
                    str(k) +
                    '. Заземление каждого рабочего места на ВЛ - заземление типа ЛЗ.'
                )
                k += 1
                pt_f = p[i][7].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
            # Пункт 3 (Разрешение работ)
            if (c4 and c5) or (c4 or c5):
                p[i][8] = document.add_paragraph(str(k) + '. ')
                pt_f = p[i][8].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
                if c4:
                    if i == 0:
                        p[i][8].add_run(
                            'Разрешаются работы на участках ВЛ опоры № ')
                    else:
                        p[i][8].add_run(
                            'Разрешаются работы на участках ответвления от ВЛ опоры № '
                        )
                    for j in range(len(s4)):
                        if j == len(s4) - 1:
                            p[i][8].add_run(s4[j] + '. ')
                        else:
                            p[i][8].add_run(s4[j] + ', ')
                if c5:
                    p[i][8].add_run(
                        'Разрешаются работы на линейном оборудовании ')
                    for j in range(len(s5)):
                        if j == len(s5) - 1:
                            p[i][8].add_run(s5[j] + '. ')
                        else:
                            p[i][8].add_run(s5[j] + ', ')
                    p[i][8].add_run(
                        'При работах на линейных разъединителях дополнительно устанавливается заземление типа ДЗ. '
                    )
                k += 1

            # Пункт 4 (если есть безопасные участки вл)
            if c4:
                p[i][9]=document.add_paragraph(str(k)+'. Разрешается работа на участке ВЛ до 2 км'\
                                            +' с установкой заземления типа ЛЗ с двух сторон участка,'\
                                            +' при условии, что их установка производится в пределах рабочего участка ВЛ.')
                k += 1
                pt_f = p[i][9].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
            # Пункт 5 (если есть запрещённые участки)
            if (c6 and c7) or (c6 or c7):
                p[i][10] = document.add_paragraph(str(k) + '. ')
                pt_f = p[i][10].paragraph_format
                pt_f.first_line_indent = Mm(12.5)
                pt_f.alignment = WD_ALIGN_PARAGRAPH.JUSTIFY  # Выравнивание по ширине
                if c6:
                    if i == 0:
                        p[i][10].add_run(
                            'Запрещаются работы на участках ВЛ опоры № ')
                    else:
                        p[i][10].add_run(
                            'Запрещаются работы на участках ответвления от ВЛ опоры № '
                        )
                    for j in range(len(s6)):
                        if j == len(s6) - 1:
                            p[i][10].add_run(s6[j] + '. ')
                        else:
                            p[i][10].add_run(s6[j] + ', ')
                if c7:
                    p[i][10].add_run(
                        'Запрещаются работы на линейном оборудовании ')
                    for j in range(len(s7)):
                        if j == len(s7) - 1:
                            p[i][10].add_run(s7[j] + '. ')
                        else:
                            p[i][10].add_run(s7[j] + ', ')
                k += 1

            # Пункт 6 (при установке ЛЗ 25 В если есть безопасные участки)
            #if c4:
            #p[i][11]=document.add_paragraph(str(k)+'. При установке заземления типа ЛЗ напряжение на рабочих '\
            #+'местах не превысит нормируемой величины 25 В.')

            # Распеределение напряжения по длинне ВЛ
            p[i][12] = document.add_paragraph()
            p[i][12].add_run('СХЕМА СБЛИЖЕНИЯ').bold = True
            pt_f = p[i][12].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)
            pt_f.space_before = Pt(10)

            # Картинка эпюры напряжения
            im = Image.open('gr_sb/' + str(i) + '.jpg')
            im.crop((80, 0, 1610, 500)).save('gr_sb/obr' + str(i) + '.jpg')
            p[i][13] = document.add_picture('gr_sb/obr' + str(i) + '.jpg',
                                            width=Inches(6.25))
            last_paragraph = document.paragraphs[-1]
            last_paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER

            p[i][14] = document.add_paragraph()
            p[i][14].add_run(
                'РАСПРЕДЕЛЕНИЕ НАПРЯЖЕНИЯ ПО ДЛИНЕ ВЛ').bold = True
            pt_f = p[i][14].paragraph_format
            pt_f.alignment = WD_ALIGN_PARAGRAPH.CENTER
            pt_f.space_after = Pt(2)
            pt_f.space_before = Pt(10)

            # Картинка эпюры напряжения
            im = Image.open('images_grafik/' + str(i) + '.jpg')
            im.crop((80, 15, 1610,
                     500)).save('images_grafik/obr' + str(i) + '.jpg', "PNG")
            p[i][15] = document.add_picture('images_grafik/obr' + str(i) +
                                            '.jpg',
                                            width=Inches(6.25))
            last_paragraph = document.paragraphs[-1]
            last_paragraph.alignment = WD_ALIGN_PARAGRAPH.CENTER

            # Разрыв страницы если нужно
            if i != len(inf) - 1:
                document.add_page_break()  # Разрыв страницы

    # Сохраняем документ
    if Trig:
        document.add_page_break()  # Разрыв страницы
        return document
    else:
        document.save(fname)
        return None