def test(self):
        """
        Test the case when Word splits a MergeField w:instrText into several pieces
        (Note the test document is a valid word document generated by Word 2007)
        """
        document = MailMerge('tests/test_split_merge.docx')
        self.assertEquals(document.get_merge_fields(),
                          set(['name_pinyin', 'name', 'semester',
                               'academic_year', 'date']))

        with tempfile.NamedTemporaryFile() as outfile:
            document.write(outfile)
    def mail_merge(self, company_name):

        #template1 = 'test1.docx'
        template2 = 'Executive_Summary2.docx'

        document = MailMerge(template2)
        print (document.get_merge_fields())
        #merge fields
        #{'ZIP_Code', 'Address_Line_2', 'Country_or_Region',
        #'Address_Line_1', 'Company_Name', 'Title',
        # 'State', 'City', 'First_Name', 'Work_Phone',
        #'Email_Address', 'Home_Phone', 'Last_Name'}

        document.merge(Title = 'Mr',
                        First_Name ='Joe',
                        Last_Name = 'OShea',
                        Company_Name = 'Principal Systems',
                        Email_Address= '*****@*****.**',
                        City = 'Dublin',
                        State = 'Dublin',
                        Work_Phone ='123333',
                        Address_Line_1 ='56 Pembrooke road',
                        Address_Line_2='Ballsbridge',
                        Home_Phone='1234567',
                        Country_or_Region='Ireland',
                        ZIP_Code = 'Dublin6')

        output = company_name + '_output.docx'
        document.write(output)
        return  output
    def mail_merge(self, template, kwargs):

        company_name = kwargs.get('Company_Name', "default company_name")
        print('******',company_name)
        print('*******************', kwargs.items())
        document = MailMerge(template)
        print (document.get_merge_fields())
        #merge fields
        #{'ZIP_Code', 'Address_Line_2', 'Country_or_Region',
        #'Address_Line_1', 'Company_Name', 'Title',
        # 'State', 'City', 'First_Name', 'Work_Phone',
        #'Email_Address', 'Home_Phone', 'Last_Name'}

        document.merge(Title=kwargs.get('Title', "default title"),
                First_Name=kwargs.get('First_Name', "default fname"),
                Last_Name=kwargs.get('Last_Name', "default lname"),
            Company_Name=kwargs.get('Company_Name', "default company_name"),
                Email_Address=kwargs.get('Email_Address', "default email"),
                City=kwargs.get('City', "default city"),
                State=kwargs.get('State', "default state"),
                Work_Phone=kwargs.get('Work_Phone', "default Work Phone"),
                Address_Line_1=kwargs.get('Address_Line_1', "Address_Line_1"),
        Address_Line_2=kwargs.get('Address_Line_2', "default Address_Line_2"),
                Home_Phone=kwargs.get('Home_Phone', "Home_Phone"),
Country_or_Region=kwargs.get('Country_or_Region', "default Country_or_Region"),
                    ZIP_Code=kwargs.get('ZIP_Code ', "default ZIP_Code "))

        output = company_name + '_output.docx'
        document.write(output)
        print(output, ' is ready')
        return  output
Exemple #4
0
    def apply_mailmerge(self, context, filename="example.docx"):
        # Return a django request response with a docx download.
        docx = StringIO()

        mailmerge = MailMerge(self.get_full_path())
        mailmerge.merge(context)
        mailmerge.write(docx)
        mailmerge.close()

        # return response
        docx.seek(0)
        response = HttpResponse(docx)
        response['Content-Disposition'] = 'attachment; filename={}'.format(filename)
        response['Content-Type'] = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
        return response
    def test_paged(self):
        document = MailMerge(path.join(path.dirname(__file__), 'test_merge_list_paged.docx'))
        self.assertEqual(document.get_merge_fields(), {'fieldname'})

        document.merge_list([
            {'fieldname': "xyz"},
            {'fieldname': "abc"},
            {'fieldname': "2b v ~2b"},
       ])

        with tempfile.TemporaryFile() as outfile:
            document.write(outfile)

        expected_tree = ElementTree.fromstring(
            '<w:document xmlns:ns1="http://schemas.openxmlformats.org/officeDocument/2006/relationships"'
            ' xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"><w:body><w:p w:rsidP="007B2B98"'
            ' w:rsidR="00507D2F" w:rsidRDefault="00651722"><w:r><w:t xml:space="preserve">This is a template for'
            ' the </w:t></w:r><w:r><w:t>xyz</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t>'
            '</w:r><w:r w:rsidR="00507D2F"><w:t>, page 1</w:t></w:r></w:p><w:p w:rsidR="00507D2F" w:rsidRDefault="00507D2F">'
            '<w:r><w:br w:type="page" /></w:r></w:p><w:p w:rsidP="007B2B98" w:rsidR="00EC3BBB" w:rsidRDefault="00507D2F"'
            ' w:rsidRPr="00651722"><w:r><w:lastRenderedPageBreak /><w:t xml:space="preserve">This is a template for the'
            ' </w:t></w:r><w:r><w:t>xyz</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t></w:r><w:r>'
            '<w:t>, page 2</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p>'
            '<w:sectPr w:rsidR="00EC3BBB" w:rsidRPr="00651722"><w:headerReference ns1:id="rId7" w:type="default" />'
            '<w:footerReference ns1:id="rId8" w:type="default" /><w:pgSz w:h="15840" w:w="12240" /><w:pgMar'
            ' w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1440" w:right="1440" w:top="1440"'
            ' /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body><w:br w:type="page" />'
            '<w:body><w:p w:rsidP="007B2B98" w:rsidR="00507D2F" w:rsidRDefault="00651722"><w:r><w:t xml:space="preserve"'
            '>This is a template for the </w:t></w:r><w:r><w:t>abc</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list'
            ' test case</w:t></w:r><w:r w:rsidR="00507D2F"><w:t>, page 1</w:t></w:r></w:p><w:p w:rsidR="00507D2F"'
            ' w:rsidRDefault="00507D2F"><w:r><w:br w:type="page" /></w:r></w:p><w:p w:rsidP="007B2B98" w:rsidR="00EC3BBB"'
            ' w:rsidRDefault="00507D2F" w:rsidRPr="00651722"><w:r><w:lastRenderedPageBreak /><w:t xml:space="preserve">'
            'This is a template for the </w:t></w:r><w:r><w:t>abc</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list'
            ' test case</w:t></w:r><w:r><w:t>, page 2</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" />'
            '<w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00EC3BBB" w:rsidRPr="00651722"><w:headerReference'
            ' ns1:id="rId7" w:type="default" /><w:footerReference ns1:id="rId8" w:type="default" /><w:pgSz w:h="15840"'
            ' w:w="12240" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1440"'
            ' w:right="1440" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body>'
            '<w:br w:type="page" /><w:body><w:p w:rsidP="007B2B98" w:rsidR="00507D2F" w:rsidRDefault="00651722"><w:r>'
            '<w:t xml:space="preserve">This is a template for the </w:t></w:r><w:r><w:t>2b v ~2b</w:t></w:r><w:r><w:t'
            ' xml:space="preserve"> merge_list test case</w:t></w:r><w:r w:rsidR="00507D2F"><w:t>, page 1</w:t></w:r>'
            '</w:p><w:p w:rsidR="00507D2F" w:rsidRDefault="00507D2F"><w:r><w:br w:type="page" /></w:r></w:p><w:p'
            ' w:rsidP="007B2B98" w:rsidR="00EC3BBB" w:rsidRDefault="00507D2F" w:rsidRPr="00651722"><w:r>'
            '<w:lastRenderedPageBreak /><w:t xml:space="preserve">This is a template for the </w:t></w:r><w:r><w:t>2b'
            ' v ~2b</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t></w:r><w:r><w:t>, page 2</w:t>'
            '</w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00EC3BBB"'
            ' w:rsidRPr="00651722"><w:headerReference ns1:id="rId7" w:type="default" /><w:footerReference ns1:id="rId8"'
            ' w:type="default" /><w:pgSz w:h="15840" w:w="12240" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0"'
            ' w:header="708" w:left="1440" w:right="1440" w:top="1440" /><w:cols w:space="708" /><w:docGrid'
            ' w:linePitch="360" /></w:sectPr></w:body></w:document>')

        self.assert_equal_tree(expected_tree, get_document_body_part(document).getroot())
    def test(self):
        document = MailMerge('tests/test_macword2011.docx')
        self.assertEquals(document.get_merge_fields(),
                          set(['first_name', 'last_name', 'country', 'state',
                               'postal_code', 'date', 'address_line', 'city']))

        document.merge(first_name='Bouke', last_name='Haarsma',
                       country='The Netherlands', state=None,
                       postal_code='9723 ZA', city='Groningen',
                       address_line='Helperpark 278d', date='May 22nd, 2013')

        with tempfile.NamedTemporaryFile() as outfile:
            document.write(outfile)
    def test(self):
        document = MailMerge('tests/test_winword2010.docx')
        self.assertEquals(document.get_merge_fields(),
                          set(['Titel', 'Voornaam', 'Achternaam',
                               'Adresregel_1', 'Postcode', 'Plaats',
                               'Provincie', 'Land_of_regio']))

        document.merge(Voornaam='Bouke', Achternaam='Haarsma',
                       Land_of_regio='The Netherlands', Provincie=None,
                       Postcode='9723 ZA', Plaats='Groningen',
                       Adresregel_1='Helperpark 278d', Titel='dhr.')

        with tempfile.NamedTemporaryFile() as outfile:
            document.write(outfile.name)
    def test(self):
        document = MailMerge(path.join(path.dirname(__file__), 'test_macword2011.docx'))
        self.assertEqual(document.get_merge_fields(),
                         set(['first_name', 'last_name', 'country', 'state',
                              'postal_code', 'date', 'address_line', 'city']))

        document.merge(first_name='Bouke', last_name='Haarsma',
                       country='The Netherlands', state=None,
                       postal_code='9723 ZA', city='Groningen',
                       address_line='Helperpark 278d', date='May 22nd, 2013')

        with tempfile.TemporaryFile() as outfile:
            document.write(outfile)

        expected_tree = etree.fromstring(
            '<w:document xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" '
            'xmlns:ns1="http://schemas.microsoft.com/office/word/2010/wordml" xmlns:w="http://schemas'
            '.openxmlformats.org/wordprocessingml/2006/main" mc:Ignorable="w14 wp14">'
            '<w:body><w:p ns1:paraId="25CDEC86" ns1:textId="77777777" '
            'w:rsidR="00FB567A" w:rsidRDefault="00541684"><w:r><w:t>Bouke</w:t></w:r><w:r w:rsidR="00916690"><w:t '
            'xml:space="preserve"> </w:t></w:r><w:r><w:t>Haarsma</w:t></w:r></w:p><w:p ns1:paraId="67F7A559" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00541684"><w:r><w:t>Helperpark '
            '278d</w:t></w:r></w:p><w:p ns1:paraId="228F2AEA" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00541684"><w:r><w:t>9723 ZA</w:t></w:r><w:r><w:t xml:space="preserve"> '
            '</w:t></w:r><w:r><w:t>Groningen</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd '
            'w:id="0" /><w:r w:rsidR="00916690"><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t /></w:r><w:r '
            'w:rsidR="00916690"><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t>The '
            'Netherlands</w:t></w:r></w:p><w:p ns1:paraId="696E15D7" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690" /><w:p ns1:paraId="3F48DA35" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690" /><w:p ns1:paraId="68E7FBD1" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690"><w:r><w:t xml:space="preserve">Groningen, </w:t></w:r><w:r><w:t>May 22nd, '
            '2013</w:t></w:r><w:r><w:t>,</w:t></w:r></w:p><w:p ns1:paraId="26B47597" ns1:textId="77777777" '
            'w:rsidR="00916690" w:rsidRDefault="00916690" /><w:p ns1:paraId="740FF493" ns1:textId="77777777" '
            'w:rsidR="00916690" w:rsidRDefault="00916690" /><w:p ns1:paraId="232699A0" ns1:textId="77777777" '
            'w:rsidR="00916690" w:rsidRDefault="00916690"><w:r><w:t xml:space="preserve">Dear '
            '</w:t></w:r><w:r><w:t>Bouke</w:t></w:r><w:r><w:t>,</w:t></w:r></w:p><w:p ns1:paraId="1AE04A19" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00916690" /><w:p ns1:paraId="298752B0" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00916690" /><w:p ns1:paraId="477BE6DB" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00916690"><w:r><w:t>I hope this message finds '
            'you well.</w:t></w:r></w:p><w:p ns1:paraId="77542CE2" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690" /><w:p ns1:paraId="734AC552" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690" /><w:p ns1:paraId="1680D84C" ns1:textId="77777777" w:rsidR="00916690" '
            'w:rsidRDefault="00916690"><w:r><w:t>Kind regards,</w:t></w:r></w:p><w:p ns1:paraId="67F698AC" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00916690" /><w:p ns1:paraId="7A4C001B" '
            'ns1:textId="77777777" w:rsidR="00916690" w:rsidRDefault="00916690"><w:r><w:t>docx-mailmerge'
            '.</w:t></w:r></w:p><w:sectPr w:rsidR="00916690" w:rsidSect="00CA5A66"><w:pgSz w:h="16840" w:w="11900" '
            '/><w:pgMar w:bottom="1417" w:footer="708" w:gutter="0" w:header="708" w:left="1417" w:right="1417" '
            'w:top="1417" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>')

        self.assert_equal_tree(expected_tree, list(document.parts.values())[0].getroot())
    def test_pages(self):
        document = MailMerge(path.join(path.dirname(__file__), 'test_merge_pages.docx'))
        self.assertEqual(document.get_merge_fields(), {'fieldname'})

        document.merge_pages([
            {'fieldname': "xyz"},
            {'fieldname': "abc"},
            {'fieldname': "2b v ~2b"},
        ])

        with tempfile.TemporaryFile() as outfile:
            document.write(outfile)

        expected_tree = etree.fromstring('<w:document xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:ns1="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" mc:Ignorable="w14 wp14"><w:body><w:p w:rsidP="007B2B98" w:rsidR="00EC3BBB" w:rsidRDefault="00651722" w:rsidRPr="00651722"><w:r><w:t xml:space="preserve">This is a template for the </w:t></w:r><w:r><w:t>xyz</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00EC3BBB" w:rsidRPr="00651722"><w:headerReference ns1:id="rId7" w:type="default" /><w:footerReference ns1:id="rId8" w:type="default" /><w:pgSz w:h="15840" w:w="12240" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1440" w:right="1440" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body><w:br w:type="page" /><w:body><w:p w:rsidP="007B2B98" w:rsidR="00EC3BBB" w:rsidRDefault="00651722" w:rsidRPr="00651722"><w:r><w:t xml:space="preserve">This is a template for the </w:t></w:r><w:r><w:t>abc</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00EC3BBB" w:rsidRPr="00651722"><w:headerReference ns1:id="rId7" w:type="default" /><w:footerReference ns1:id="rId8" w:type="default" /><w:pgSz w:h="15840" w:w="12240" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1440" w:right="1440" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body><w:br w:type="page" /><w:body><w:p w:rsidP="007B2B98" w:rsidR="00EC3BBB" w:rsidRDefault="00651722" w:rsidRPr="00651722"><w:r><w:t xml:space="preserve">This is a template for the </w:t></w:r><w:r><w:t>2b v ~2b</w:t></w:r><w:r><w:t xml:space="preserve"> merge_list test case</w:t></w:r><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00EC3BBB" w:rsidRPr="00651722"><w:headerReference ns1:id="rId7" w:type="default" /><w:footerReference ns1:id="rId8" w:type="default" /><w:pgSz w:h="15840" w:w="12240" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1440" w:right="1440" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>')  # noqa

        self.assert_equal_tree(expected_tree, get_document_body_part(document).getroot())
    def test(self):
        document = MailMerge(path.join(path.dirname(__file__), 'test_winword2010.docx'))
        self.assertEqual(document.get_merge_fields(),
                         set(['Titel', 'Voornaam', 'Achternaam',
                              'Adresregel_1', 'Postcode', 'Plaats',
                              'Provincie', 'Land_of_regio']))

        document.merge(Voornaam='Bouke', Achternaam='Haarsma',
                       Land_of_regio='The Netherlands', Provincie=None,
                       Postcode='9723 ZA', Plaats='Groningen',
                       Adresregel_1='Helperpark 278d', Titel='dhr.')

        with tempfile.NamedTemporaryFile() as outfile:
            document.write(outfile)

        expected_tree = ElementTree.fromstring(
            '<w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"><w:body><w:p '
            'w:rsidR="00886208" w:rsidRDefault="00886208"><w:r><w:t>dhr.</w:t></w:r><w:r '
            'w:rsidRPr="00886208"><w:rPr><w:lang w:val="nl-NL" /></w:rPr><w:t xml:space="preserve"> '
            '</w:t></w:r><w:r><w:t>Bouke</w:t></w:r><w:r w:rsidRPr="00886208"><w:rPr><w:lang w:val="nl-NL" '
            '/></w:rPr><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t>Haarsma</w:t></w:r></w:p><w:p '
            'w:rsidR="00886208" w:rsidRDefault="00886208" w:rsidRPr="00886208"><w:pPr><w:rPr><w:lang w:val="nl-NL" '
            '/></w:rPr></w:pPr><w:r><w:t>Helperpark 278d</w:t></w:r></w:p><w:p w:rsidR="00886208" '
            'w:rsidRDefault="00886208"><w:r><w:t>9723 ZA</w:t></w:r><w:r w:rsidRPr="00886208"><w:rPr><w:lang '
            'w:val="nl-NL" /></w:rPr><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t>Groningen</w:t></w:r><w:r '
            'w:rsidRPr="00886208"><w:rPr><w:lang w:val="nl-NL" /></w:rPr><w:t xml:space="preserve"> '
            '</w:t></w:r><w:r><w:t /></w:r><w:r w:rsidRPr="00886208"><w:rPr><w:lang w:val="nl-NL" /></w:rPr><w:t '
            'xml:space="preserve"> </w:t></w:r><w:r><w:t>The Netherlands</w:t></w:r></w:p><w:p w:rsidR="00886208" '
            'w:rsidRDefault="00886208" /><w:p w:rsidR="00886208" w:rsidRDefault="00886208"><w:r><w:t>Groningen,'
            '</w:t></w:r></w:p><w:p w:rsidR="00886208" w:rsidRDefault="00886208"><w:bookmarkStart w:id="0" '
            'w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:p w:rsidR="004D7161" '
            'w:rsidRDefault="00886208"><w:r><w:t xml:space="preserve">Dear '
            '</w:t></w:r><w:r><w:t>Bouke</w:t></w:r><w:r><w:t>,</w:t></w:r></w:p><w:p w:rsidR="00886208" '
            'w:rsidRDefault="00886208" /><w:p w:rsidR="00886208" w:rsidRDefault="00886208"><w:r><w:t>I hope this '
            'document from WinWord 2010 finds you well.</w:t></w:r></w:p><w:p w:rsidR="00886208" '
            'w:rsidRDefault="00886208" /><w:p w:rsidR="00886208" w:rsidRDefault="00886208"><w:r><w:t>Kind regards,'
            '</w:t></w:r></w:p><w:p w:rsidR="00886208" w:rsidRDefault="00886208" '
            'w:rsidRPr="00886208"><w:pPr><w:rPr><w:lang w:val="en-US" /></w:rPr></w:pPr><w:proofErr '
            'w:type="spellStart" /><w:r><w:t>docx-mailmerge</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r><w:t>'
            '.</w:t></w:r></w:p><w:sectPr w:rsidR="00886208" w:rsidRPr="00886208"><w:pgSz w:h="16838" w:w="11906" '
            '/><w:pgMar w:bottom="1417" w:footer="708" w:gutter="0" w:header="708" w:left="1417" w:right="1417" '
            'w:top="1417" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>')

        self.assert_equal_tree(expected_tree, list(document.parts.values())[0].getroot())
Exemple #11
0
from __future__ import print_function
from mailmerge import MailMerge
import datetime as date

template = "Amnova Quote Template.docx"

document = MailMerge(template)
print(document.get_merge_fields())

today = date.date.today()
nextWeek = today + date.timedelta(days=7)

document.merge(invoiceNumber="AB001",
               invoiceDate='{:%d-%b-%Y}'.format(date.date.today()),
               clientCompany="The Anderson Lid Company",
               dueDate=str(nextWeek))

invoice_list = [{
    'description': 'SPI TRAY: 3D Printing Service (Large Format)',
    'quantity': '40.00',
    'unitPrice': '20.00',
    'amount': '800.00'
}, {
    'description': 'SPI TRAY: 3D Printing Filament (PETG)',
    'quantity': '0.796',
    'unitPrice': '1,250.00',
    'amount': '995.00'
}, {
    'description': 'SPI TRAY: Printer Setup',
    'quantity': '1.00',
    'unitPrice': '50.00',
Exemple #12
0
def response_sthlm(bidragcontainer):
    per_diem = 35  # Amount per scout per day 2021
    h1_end = datetime(2021, 5, 31, 23, 59)

    bidrag = bidragcontainer.bidrag
    persons = bidragcontainer.persons

    nr_persons = bidragcontainer.nr_persons_total
    persons = persons[:nr_persons]

    start = datetime.strptime(bidrag.dateFrom, DATE_FORMAT)
    end = datetime.strptime(bidrag.dateTo, DATE_FORMAT)
    nr_days = (end - start).days + 1

    if bidrag.zipCode != "":
        zcParts = bidrag.zipCode.split()
        postnr = "".join(zcParts[:-1])  # remove possible space in zip code
        postort = zcParts[-1]

    today = date.today()
    data = {
        'organisationsnummer': bidrag.organisationsnummer,
        'kontonummer': bidrag.kontonummer,
        'kundnummer': bidrag.foreningsID,
        'foreningsnamn': bidrag.kar,
        'epost': bidrag.email,
        'ledare': bidrag.contact,
        'ledartelefon': bidrag.contactphone,
        'ledaremail': bidrag.contactemail,
        'lov': u'X' if bidrag.hikeduringbreak else u'\u2610',
        'helg': u'\u2610' if bidrag.hikeduringbreak else u'X',
        'lagerplats': bidrag.site,
        'startdatum': bidrag.dateFrom,
        'slutdatum': bidrag.dateTo,
        'datum': today.strftime(DATE_FORMAT),
        'dag': str(today.day),
        'manad': str(today.month),
        'ordforande': bidrag.firmatecknare,
        'ordforandetelefon': bidrag.firmatecknartelefon,
        'ordforandeemail': bidrag.firmatecknaremail,
        'adress': bidrag.address,
        'postnr': postnr,
        'postort': postort,
        'bankkonto': bidrag.account,
        'antalmedlemmar': str(bidragcontainer.nr_young_persons),
        'antaldagar': str(nr_days),  # Should be total number of days
        'summa': str(bidrag.days * per_diem) + ",00",
        'H1': u'\u2610' if h1_end <= end else u'X',
        'H2': u'\u2610' if h1_end > end else u'X'
    }

    period_data = generate_sthlm_period_data(today.year, today.month,
                                             today.day)
    data.update(period_data)

    persons_per_page = 25
    nr_pages, rest = divmod(nr_persons, persons_per_page)
    if rest > 0:
        nr_pages += 1
    pages = []
    for page_nr in range(nr_pages):
        page_data = copy.deepcopy(data)
        persons_in_page = persons[page_nr * persons_per_page:(page_nr + 1) *
                                  persons_per_page]
        for i, person in enumerate(persons_in_page):
            nr = i + 1
            page_data['namn%d' % nr] = person.name
            page_data['pa%d' % nr] = person.postal_address
            page_data['ar%d' % nr] = str(person.year)
            if person.days != nr_days:
                page_data['ad%d' % nr] = str(person.days)
        pages.append(page_data)

    document = MailMerge('templates/lagerbidragsmall_sthlm_2021.docx')
    document.merge_pages(pages)

    bytesIO = io.BytesIO()
    document.write(bytesIO)
    resultbytes = bytesIO.getvalue()

    doc_name = "Lagerbidrag_%s_%s_%s.docx" % (bidrag.site, bidrag.dateFrom,
                                              bidrag.dateTo)
    ascii_doc_name = doc_name.encode('ascii', 'ignore')

    response = make_response(resultbytes)
    response.headers[
        'Content-Type'] = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
    response.headers[
        'Content-Disposition'] = 'attachment; filename=' + urllib.quote(
            ascii_doc_name)
    return response
if template == "Prueba1.docx":
    materia = "recargo prestaciones"
elif template == "Prueba5.docx":
    materia = "recargo prestaciones"
elif template == "Extincion retraso pago.docx":
    materia = "extincion contrato"
elif template == "Extincion falta de pago.docx":
    materia = "extincion contrato"
elif template == "Extincion modificacion sustancial.docx":
    materia = "extincion contrato"
else:
    materia = "recargo prestaciones"

# uso del template elegido

document = MailMerge(template)


# creación de función para ver si la opción de indemnización ha sido seleccionada y rellenada, en caso contrario no hace nada

def indemnizacionsiono():
    if entry_var23.get():
        return indemnizacion_despido_prueba(str(entry_var21.get()), str(entry_var23.get()), str(today))
    else:
        valor0 = 0
        return valor0


# crear funcion de mayusculas y minusculas actor

def actorcapitalizacion():
print(r.status_code)

#se crea un diccionario con el json que viene del response para la cedula consultada
dict_emp = {}

#esto lo que va a hacer es quitar el primer elemento del diccionario para que solo quede la info que viene del web service
dict_emp = r.json()[-1]

# imprimimos el contenido para ver que informacion nos trajo
print(dict_emp)

# guardamos el template de la constancia en la variable template
template = "Constancia_salarial_template.docx"

#Creamos un documento mailmerge que contiene la informacion del template
document = MailMerge(template)
#imprimimos el contenido del objeto para ver todos los campos a llenar que contiene
print(document.get_merge_fields())

#Funcion para insertar info en Doc de word

#Funcion para calcular el salario Neto, recibe el salario bruto por parametro
#calculo de renta:
#817 - 1,226: 10%
#1,226 - 2,103: 15%
#2,103 - 4,205: 20%
#4,205+ : 25%


def calcSalarioNeto(salarioBruto):
    salarioNeto = 0
 def test(self):
     document = MailMerge(
         path.join(path.dirname(__file__), 'test_issue8.docx'))
     self.assertEqual(document.get_merge_fields(), {'testfield'})
    def main(self):
        list_columns = ['Global ID', 'Local Name', 'Status', 'Notes']
        df_list = pd.DataFrame(columns=list_columns)
        self.read_files()

        for n_idx, n_row in self.df_data.iterrows():

            lv_template = self.template
            document_1 = MailMerge(self.path + lv_template)

            try:

                dict = {
                    "Global_ID":
                    str(n_row['Global ID']),
                    "English_Name":
                    str(n_row['English Name']),
                    "Local_Name":
                    str(n_row['Local Name']),
                    "Department":
                    str(n_row['Department']),
                    "Performance_Rating":
                    n_row['Performance Rating'],
                    "Bonus_Amount":
                    '{:.2f}'.format(n_row['Bonus_Amount']),
                    "Individual_Modifier":
                    '{:.2f}'.format(n_row['Individual Modifier']),
                    # "Individual_Modifier": '{:.2f}%'.format(n_row['Individual Modifier']),
                    "Business_Modifier":
                    '{:.2f}'.format(n_row['Business Modifier']),
                    "Payout_Rate":
                    '{:.2f}'.format(n_row['Payout Rate']),
                }
                document_1.merge(**dict)

                file_path = self.path + 'xlsx/'
                if not os.path.exists(file_path):
                    os.makedirs(file_path)
                # filename
                lv_name = self.prefix + str(
                    n_row['Global ID']) + '_' + n_row['Local Name']
                file_docx = self.path + 'xlsx/' + lv_name + '.docx'
                document_1.write(file_docx)
                # time.sleep(1)

                file_path = self.path + 'pdf' + '/' + n_row['HRBP'] + '/'
                if not os.path.exists(file_path):
                    os.makedirs(file_path)

                if n_row['Division'] != "":
                    file_path = file_path + n_row['Division'] + '/'
                    if not os.path.exists(file_path):
                        os.makedirs(file_path)

                if n_row['Division2'] != "":
                    file_path = file_path + n_row['Division2'] + '/'
                    if not os.path.exists(file_path):
                        os.makedirs(file_path)

                if n_row['Division3'] != "":
                    file_path = file_path + n_row['Division3'] + '/'
                    if not os.path.exists(file_path):
                        os.makedirs(file_path)

                file_pdf = file_path + lv_name + '.pdf'

                convert(file_docx, file_pdf, keep_active=True)
                print('Success:', n_row['Local Name'], n_idx + 1)
                document_1.close()

                emp_line = [n_row['Global ID'], n_row['Local Name'], 'S', '']
                df_list = df_list.append(pd.Series(emp_line,
                                                   index=list_columns),
                                         ignore_index=True)

            except Exception as e:
                print('Failed to generate file for line ', n_idx + 1, e)
                emp_line = [n_row['Global ID'], n_row['Local Name'], 'E', '']
                df_list = df_list.append(pd.Series(emp_line,
                                                   index=list_columns),
                                         ignore_index=True)
        df_list.to_csv(self.path + 'log.csv')
Exemple #17
0
    def replace_mailing_merge_and_convert_to_pdf(self):

        with open(self.data_mailingMerge) as f:
            data = json.load(f)['data']
        len_data = len(data)

        if not os.path.exists(self.output_Word):
            os.makedirs(self.output_Word)

        if not os.path.exists(self.output_PDF):
            os.makedirs(self.output_PDF)

        if self.multiple_files:
            for index, input in enumerate(data):
                print('creating {}/{} ...'.format(index, len_data))
                document = MailMerge(self.word_template)
                document.merge(**input)

                word_output = os.path.join(
                    self.output_Word, self.fileName_prefix + str(index + 1) +
                    self.word_extension)
                document.write(word_output)

                # convert to PDF
                if self.convert_to_pdf:
                    subprocess.check_output([
                        '/Applications/LibreOffice.app/Contents/MacOS/soffice',
                        '--convert-to', 'pdf', '--outdir', self.output_PDF,
                        word_output
                    ])
        else:
            print("creating one file containing {} mails...".format(len_data))
            document = MailMerge(self.word_template)
            document.merge_pages(data)

            word_output = os.path.join(
                self.output_Word, self.fileName_prefix + self.word_extension)
            document.write(word_output)

            # convert to PDF
            if self.convert_to_pdf:
                subprocess.check_output([
                    '/Applications/LibreOffice.app/Contents/MacOS/soffice',
                    '--convert-to', 'pdf', '--outdir', self.output_PDF,
                    word_output
                ])

        print('replace_mailingMerge_and_convertToPDF is done !')
Exemple #18
0
def get_values_adolecente():
    template = MailMerge("moulage_temp.docx")
    name = str(input("Nom et prénom du patient: "))
    age = str(input("Age du patient: "))
    overjet = float(input("Overjet: "))
    overbite = float(input("Overbite: "))

    ######################  Superieure
    _11 = float(input("diam MD de la 11: "))
    _12 = float(input("diam MD de la 12: "))
    _13 = float(input("diam MD de la 13: "))
    _14 = float(input("diam MD de la 14: "))
    _15 = float(input("diam MD de la 15: "))
    _21 = float(input("diam MD de la 21: "))
    _22 = float(input("diam MD de la 22: "))
    _23 = float(input("diam MD de la 23: "))
    _24 = float(input("diam MD de la 24: "))
    _25 = float(input("diam MD de la 25: "))
    _16 = float(input("diam MD de la 16: "))
    l_sup_m = float(input("longueur d'arcade supérieure: "))
    d4g4_sup_m = float(input("D4G4 supérieure: "))
    d6g6_sup_m = float(input("D6G6 supérieure: "))
    l_base = float(input("Longeur de base maxillaire: "))
    if (_14 + _15 + _24 + _25 == 0):
        ED_sup = float(input("Espace disponible supérieure: ")) - 1.8
    if (_14 + _15 == 0) and (_24 + _25 != 0):
        ED_sup = float(input("Espace disponible supérieure: ")) - 0.9
    if (_14 + _15 != 0) and (_24 + _25 != 0):
        ED_sup = float(input("Espace disponible supérieure: "))

    #######################  Inferieure
    _31 = float(input("diam MD de la 31: "))
    _32 = float(input("diam MD de la 32: "))
    _33 = float(input("diam MD de la 33: "))
    _34 = float(input("diam MD de la 34: "))
    _35 = float(input("diam MD de la 35: "))
    _41 = float(input("diam MD de la 41: "))
    _42 = float(input("diam MD de la 42: "))
    _43 = float(input("diam MD de la 43: "))
    _44 = float(input("diam MD de la 44: "))
    _45 = float(input("diam MD de la 45: "))
    l_inf_m = float(input("longueur d'arcade inférieure: "))
    d4g4_inf_m = float(input("D4G4 inférieure: "))
    d6g6_inf_m = float(input("D6G6 inférieure: "))
    if (_34 + _35 + _44 + _45 == 0):
        ED_inf = float(input("Espace disponible supérieure: ")) - 3.4
    if (_34 + _35 == 0) and (_44 + _45 != 0):
        ED_inf = float(input("Espace disponible supérieure: ")) - 1.7
    if (_34 + _35 != 0) and (_44 + _45 != 0):
        ED_inf = float(input("Espace disponible supérieure: "))

    #######################  Calcules
    if _13 == 0 and _23 != 0:
        _13 == _23
    if _23 == 0 and _13 != 0:
        _23 == _13

    if _14 == 0 and _24 != 0:
        _14 == _24
    if _24 == 0 and _14 != 0:
        _24 == _14

    if _15 == 0 and _25 != 0:
        _15 == _25
    if _25 == 0 and _15 != 0:
        _25 == _15

    EN_inf_TJ = _31 + _32 + _33 + _34 + _35 + _41 + _42 + _43 + _44 + _45
    EN_sup_TJ = _11 + _12 + _13 + _14 + _15 + _21 + _22 + _23 + _24 + _25
    p10 = (_11 + _14 + _16) * 2.84
    p14 = (_11 + _14 + _16) * 4.4
    l_sup_t = round((p10 / 2.58), 2)
    l_inf_t = round((p10 / 3.10), 2)
    d4g4_sup_t = round((p14 * 0.32), 2)
    d6g6_sup_t = round((p14 * 0.4), 2)
    d4g4_inf_t = round((p10 / 2.32), 2)
    d6g6_inf_t = round((p10 / 1.76), 2)
    ddm_sup = round((ED_sup - EN_sup_TJ), 2)
    ddm_inf = round((ED_inf - EN_inf_TJ), 2)

    #######################  Merge
    template.merge(name=name,
                   age=age,
                   overbite=str(overbite),
                   overjet=str(overjet),
                   p10=str(p10),
                   p14=str(p14),
                   d4g4_sup_m=str(d4g4_sup_m),
                   d4g4_sup_t=str(d4g4_sup_t),
                   d6g6_sup_m=str(d6g6_sup_m),
                   d6g6_sup_t=str(d6g6_sup_t),
                   l_sup_m=str(l_sup_m),
                   l_sup_t=str(l_sup_t),
                   l_base=str(l_base),
                   ddm_sup=str(ddm_sup))
    template.merge(d4g4_inf_m=str(d4g4_inf_m),
                   d4g4_inf_t=str(d4g4_inf_t),
                   d6ag6_inf_m=str(d6g6_inf_m),
                   d6g6_inf_t=str(d6g6_inf_t),
                   l_inf_m=str(l_inf_m),
                   l_inf_t=str(l_inf_t),
                   ddm_inf=str(ddm_inf))
    template.write("{}.docx".format(name))
Exemple #19
0
def get_values_mixte():
    template = MailMerge("moulage_temp.docx")
    name = str(input("Nom et prénom du patient: "))
    age = str(input("Age du patient: "))
    overjet = float(input("Overjet: "))
    overbite = float(input("Overbite: "))

    ######################  Superieure
    _11 = float(input("diam MD de la 11: "))
    _12 = float(input("diam MD de la 12: "))
    _21 = float(input("diam MD de la 21: "))
    _22 = float(input("diam MD de la 22: "))
    _16 = float(input("diam MD de la 16: "))
    l_sup_m = float(input("longueur d'arcade supérieure: "))
    d4g4_sup_m = float(input("D4G4 supérieure: "))
    d6g6_sup_m = float(input("D6G6 supérieure: "))
    l_base = float(input("Longeur de base maxillaire: "))
    ED_sup = float(input("Espace disponible supérieure: ")) - 1.8

    #######################  Inferieure
    _31 = float(input("diam MD de la 31: "))
    _32 = float(input("diam MD de la 32: "))
    _41 = float(input("diam MD de la 41: "))
    _42 = float(input("diam MD de la 42: "))
    l_inf_m = float(input("longueur d'arcade inférieure: "))
    d4g4_inf_m = float(input("D4G4 inférieure: "))
    d6g6_inf_m = float(input("D6G6 inférieure: "))
    ED_inf = float(input("Espace disponible inférieure: ")) - 3.4

    #######################  Calcules
    EN_inf_TJ = 2 * (_31 + _32 + _41 + _42) + 21
    EN_sup_TJ = (_11 + _12 + _21 + _22) + (_31 + _32 + _41 + _42) + 22
    p10 = (_11 + _16) * 3.85
    p14 = (_11 + _16) * 5.95

    l_sup_t = round((p10 / 2.58), 2)
    l_inf_t = round((p10 / 3.10), 2)
    d4g4_sup_t = round((p14 * 0.32), 2)
    d6g6_sup_t = round((p14 * 0.4), 2)
    d4g4_inf_t = round((p10 / 2.32), 2)
    d6g6_inf_t = round((p10 / 1.76), 2)

    ddm_sup = ED_sup - EN_sup_TJ
    ddm_inf = ED_inf - EN_inf_TJ

    #######################  Merge
    template.merge(name=name,
                   age=age,
                   overbite=str(overbite),
                   overjet=str(overjet),
                   p10=str(p10),
                   p14=str(p14),
                   d4g4_sup_m=str(d4g4_sup_m),
                   d4g4_sup_t=str(d4g4_sup_t),
                   d6g6_sup_m=str(d6g6_sup_m),
                   d6g6_sup_t=str(d6g6_sup_t),
                   l_sup_m=str(l_sup_m),
                   l_sup_t=str(l_sup_t),
                   l_base=str(l_base),
                   ddm_sup=str(ddm_sup))
    template.merge(d4g4_inf_m=str(d4g4_inf_m),
                   d4g4_inf_t=str(d4g4_inf_t),
                   d6g6_inf_m=str(d6g6_inf_m),
                   d6g6_inf_t=str(d6g6_inf_t),
                   l_inf_m=str(l_inf_m),
                   l_inf_t=str(l_inf_t),
                   ddm_inf=str(ddm_inf))
    template.write("{}.docx".format(name))
Exemple #20
0
from __future__ import print_function
from mailmerge import MailMerge

docfile = 'resume_maker/my_resume.docx'

document = MailMerge(template)
print(document.get_merge_fields())

document.merge(test='test sucess')

document.write('test-output.docx')
Exemple #21
0
# -*- coding: utf-8 -*-
"""
Created on Sat Nov 16 17:46:10 2019

@author: Kratik Saxena
"""

from mailmerge import MailMerge
from datetime import date

#df=pd.read_csv('PythonExport.csv')
#print(df.iloc[0,1])

template = "TEMPLATE.docx"
document = MailMerge(template)
print(document.get_merge_fields())
di={"Name":"Sherni"}
document.merge(
    X_PAT_1_NUMBER ='Gold',
    X_PAT_2_NUMBER ='Springfield',
    X_PAT_3_NUMBER = 'US',
    X_PAT_1_TITLE = 'abc',
    X_PAT_2_TITLE = 'bca',
    X_PAT_3_TITLE = 'cab',
    X_PAT_1_ASSIGNEE = 'xyz',
    X_PAT_2_ASSIGNEE = 'yzx',
    X_PAT_3_ASSIGNEE = 'zxy',
    X_PAT_1_PUBDATE = 'qwe',
    X_PAT_2_PUBDATE = 'weq',
    X_PAT_3_PUBDATE = 'eqw',
    X_PAT_1_APPDATE = 'alsmj',
    def main(self):
        list_columns = ['Global ID', 'Employee Name', 'Status', 'Notes']
        df_list = pd.DataFrame(columns=list_columns)
        self.read_files()

        for n_idx, n_row in self.df_data.iterrows():
            if len(str(n_row['Target Move Date'])) > 0:
                if n_row['Template'] == 'fix':
                    lv_template = self.template_fix
                else:
                    lv_template = self.template
                document_1 = MailMerge(self.path + lv_template)
                # print(document_1.get_merge_fields())
                # isinstance(['Target Move Date'], datetime):

                try:
                    lv_target_cn = n_row['Target Move Date'].strftime(
                        "%Y年%m月%d日")
                    lv_target_en = n_row['Target Move Date'].strftime(
                        "%d/%m/%Y")
                    lv_start_en = n_row['Start date of ZF Service'].strftime(
                        "%d/%m/%Y")
                    lv_start_cn = n_row['Start date of ZF Service'].strftime(
                        "%Y年%m月%d日")
                    if n_row['Template'] == 'fix':
                        lv_contract_end = ''
                        lv_contract_end_cn = ''
                    else:
                        lv_contract_end = n_row[
                            'Latest Contract ending date'].strftime("%d/%m/%Y")
                        lv_contract_end_cn = n_row[
                            'Latest Contract ending date'].strftime(
                                "%Y年%m月%d日")
                        print(lv_contract_end_cn)
                        # lv_contract_end = n_row['Latest Contract ending date'].to_timestamp().strftime("%d/%m/%Y")
                        # lv_date = time.localtime(time.mktime(time.strptime(n_row['Latest Contract ending date'],'%Y-%m-%d')))
                        # # print(lv_date)
                        # # lv_contract_end = time.strptime("%d/%m/%Y %H:%M:%S",lv_date)
                        # # print(lv_contract_end)
                        # # lv_contract_end_cn = n_row['Latest Contract ending date'].to_timestamp().strftime("%Y年%m月%d日")
                        # # print(lv_contract_end_cn)
                        # lv_contract_end_cn = '至' + str(lv_date.tm_year) +'年' + str(lv_date.tm_mon) + '月' + str(lv_date.tm_mday) + '日止'
                        # lv_contract_end = 'lasts until ' + str(lv_date.tm_mday) + '/' + str(lv_date.tm_mon) + '/' + str(lv_date.tm_year)

                    dict = {
                        "Chinese_Name": str(n_row['Chinese Name']),
                        "Employee_Name": str(n_row['Employee Name']),
                        "National_ID": str(n_row['National ID']),
                        #                    "Start_date_of_ZF_Service": str(n_row['Start date of ZF Service']),
                        #                    "Target_Move_Date": str(n_row['Target Move Date'])
                        "Target_Move_Date": lv_target_en,
                        "Target_Move_Date_CN": lv_target_cn,
                        "Start_date_of_ZF_Service": lv_start_en,
                        "Start_date_of_ZF_Service_CN": lv_start_cn,
                        "Contract_End_CN": lv_contract_end_cn,
                        "Contract_End": lv_contract_end,
                    }
                    document_1.merge(**dict)

                    file_path = self.path + 'xlsx/'
                    if not os.path.exists(file_path):
                        os.makedirs(file_path)

                    lv_name = self.prefix + n_row[
                        'Division for list'] + '_' + n_row['Employee Name']
                    file_docx = self.path + 'xlsx/' + lv_name + '.docx'
                    document_1.write(file_docx)
                    # time.sleep(1)

                    file_path = self.path + 'pdf' + '/' + n_row['HR BP2'] + '/'
                    if not os.path.exists(file_path):
                        os.makedirs(file_path)

                    if n_row['Mark'] != "":
                        file_path = file_path + n_row['Mark'] + '/'
                        if not os.path.exists(file_path):
                            os.makedirs(file_path)

                    #                file_pdf = file_path + 'pdf/' + lv_name + '.pdf'
                    file_pdf = file_path + lv_name + '.pdf'
                    # file_pdf = self.path + 'pdfs/' + n_row['姓名'] + '.pdf'
                    # self.generate_pdf(file_docx,file_pdf)
                    convert(file_docx, file_pdf, keep_active=True)
                    print('Success:', n_row['Employee Name'], n_idx + 1)
                    document_1.close()

                    emp_line = [
                        n_row['Globle ID'], n_row['Employee Name'], 'S', ''
                    ]
                    df_list = df_list.append(pd.Series(emp_line,
                                                       index=list_columns),
                                             ignore_index=True)

                except Exception as e:
                    print('Failed to generate file for line ', n_idx + 1, e)
                    emp_line = [
                        n_row['Globle ID'], n_row['Employee Name'], 'E', ''
                    ]
                    df_list = df_list.append(pd.Series(emp_line,
                                                       index=list_columns),
                                             ignore_index=True)
        df_list.to_csv(self.path + 'log.csv')
Exemple #23
0
    def write_file(self):

        feedbacks = []
        feedback_secretary = Feedback()
        feedback_lib = Feedback()
        feedback_fin = Feedback()
        feedback_coord = Feedback()
        feedback_napes = Feedback()
        feedback_dir = Feedback()
        feedback_caa = Feedback()

        for feedback in self.solicitation.feedbacks.all():

            if feedback.feedbacker.usuario.is_secretary:
                feedback_secretary = feedback

            elif feedback.feedbacker.usuario.is_library:
                feedback_lib = feedback

            elif feedback.feedbacker.usuario.is_finance:
                feedback_fin = feedback

            elif feedback.feedbacker.usuario.is_coordination:
                feedback_coord = feedback

            elif feedback.feedbacker.usuario.is_napes:
                feedback_napes = feedback

            elif feedback.feedbacker.usuario.is_director:
                feedback_dir = feedback

            elif feedback.feedbacker.usuario.is_caa:
                feedback_caa = feedback

        document = MailMerge(self.template)

        print(document.get_merge_fields())

        document.merge(order=self.solicitation.order,
                       date=str(self.solicitation.created_at.day) + "/" +
                       str(self.solicitation.created_at.month) + "/" +
                       str(self.solicitation.created_at.year),
                       name=self.solicitation.student.usuario.name,
                       code=self.solicitation.code,
                       email=self.solicitation.email,
                       course=("Tecnólogo em gestão pública"),
                       phone1=self.solicitation.phone1,
                       phone2=self.solicitation.phone2,
                       semester=self.solicitation.student_semester,
                       classs=self.solicitation.classs,
                       student_academic_situation=self.solicitation.
                       student_academic_situation,
                       solicitation=self.solicitation.solicitation,
                       reason=self.solicitation.reason,
                       secretary_feedback=feedback_secretary.feedback,
                       coord_feedback=feedback_coord.feedback,
                       dir_feedback=feedback_dir.feedback,
                       napes_feedback=feedback_napes.feedback,
                       lib_feedback=feedback_lib.feedback,
                       finance_feedback=feedback_fin.feedback,
                       caa_feedback=feedback_caa.feedback)

        document.write(
            "secretariavirtual/common-static/static/solicitations/" +
            self.document_name)
for idbarang in daftar_barang:
	nama_barang		= idbarang[0]
	nama_file		= str(nama_barang);
	#nama_file		= nama_file.replace("/", "")
	#nama_lokasi	= db.escape_string(nama_lokasi)
	sql = '''
		SELECT barang.`NAMABARANG`, barang.`KODEBARANG`, barang.`JUMLAHBARANG`, barang.`HARGABARANG`,barang.`TANGGALMASUK`, kondisi.`NAMAKONDISI`, merk.`NAMAMERK`, sumber.`NAMASUMBER`, lokasi.`NAMALOKASI` 
		FROM barang INNER JOIN kondisi ON kondisi.`IDKONDISI` = barang.`IDKONDISI`
		INNER JOIN merk ON merk.`IDMERK` = barang.`IDMERK` 
		INNER JOIN sumber ON sumber.`IDSUMBER` = barang.`IDSUMBER` 
		INNER JOIN lokasi ON lokasi.`IDLOKASI` = barang.`IDLOKASI` WHERE barang.IDBARANG =''' + str(nama_barang) +  " GROUP BY barang.`IDBARANG`"
	#print sql
	cur.execute(sql)

	data = []
	document = MailMerge(path+'LabelSDMI1.docx')
	for row in cur.fetchall():
		i = row[2]
		for x in range(i):
			temp = {}
			temp['tahun'] = str(row[4].year)
			temp['asal_dana']		= row[7]
			temp['nama_barang']		= row[0]
			temp['no_barang']		= row[1]
			temp['lokasi'] = row[8]
			temp['no'] = str(x+1)
			data.append(temp)

	document.merge_rows('no_barang', data)
	document.write(path+nama_file + '.docx')
 def setUp(self):
     self.document = MailMerge(path.join(path.dirname(__file__), 'test_merge_table_multipart.docx'))
     self.expected_xml = '<w:document xmlns:ns1="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"><w:body><w:p w:rsidP="00DA4DE0" w:rsidR="00231DA5" w:rsidRDefault="00DA4DE0"><w:pPr><w:pStyle w:val="Ttulo" /></w:pPr><w:r><w:t>Grades</w:t></w:r></w:p><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>Bouke Haarsma</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:r w:rsidR="00DA4DE0"><w:t>received the grades</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> for </w:t></w:r><w:r><w:t /></w:r><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> in the table below.</w:t></w:r></w:p><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" /><w:tbl><w:tblPr><w:tblStyle w:val="Sombreadoclaro-nfasis1" /><w:tblW w:type="auto" w:w="0" /><w:tblLook w:val="04E0" /></w:tblPr><w:tblGrid><w:gridCol w:w="1777" /><w:gridCol w:w="4894" /><w:gridCol w:w="1845" /></w:tblGrid><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="100000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:r><w:t>Class Code</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:val="100000000000" /></w:pPr><w:r><w:t>Class Name</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:val="100000000000" /></w:pPr><w:r><w:t>Grade</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>ECON101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Economics 101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>ECONADV</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Economics Advanced</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>B</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>OPRES</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Operations Research</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00C829DD" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="010000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:r><w:t>THESIS</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:val="010000000000" /></w:pPr><w:r><w:t>Final thesis</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="010000000000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr></w:tbl><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" w:rsidRPr="00DA4DE0"><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00DA4DE0" w:rsidRPr="00DA4DE0" w:rsidSect="003B4151"><w:headerReference ns1:id="rId7" w:type="default" /><w:pgSz w:h="16840" w:w="11900" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1800" w:right="1800" w:top="1672" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>'
     self.expected_tree = etree.fromstring(self.expected_xml) 
Exemple #26
0
def generate_doc(template, data, output):
    document = MailMerge((template))
    document.merge(**data)
    print(document.get_merge_fields())
    document.write(output)
Exemple #27
0
def show():
    read_excel()
    new_folder()
    a = []
    for var in v:
        a.append(var.get())

    #模板文档
    template0_ELB = r".\tem\ELB_template.docx"
    template1_ELCK = r".\tem\ELCK_template.docx"
    template2_ELF = r".\tem\ELF_template.docx"
    template3_ELM = r".\tem\ELM_template.docx"
    template4_ELN = r".\tem\ELN_template.docx"
    template5_ELP = r".\tem\ELP_template.docx"
    template6_ELQC = r".\tem\ELQC_template.docx"
    template7_ELW = r".\tem\ELW_template.docx"
    template8_ELHC = r".\tem\ELHC_template.docx"
    template9_ELSMT = r".\tem\ELSMT_template.docx"
    template10_ELT = r".\tem\ELT_template.docx"
    template11_ELY = r".\tem\ELY_template.docx"
    template12_FIL_H = r".\tem\ELFIL_film_h.docx"
    template13_FIL_X = r".\tem\ELFIL_film_x.docx"
    template14_ELREF = r".\tem\ELREF_template.docx"
    template15_ELPCB = r".\tem\ELPCB_template.docx"

    #主判断
    if a[0] == 1:  #ELB
        document0 = MailMerge(template0_ELB)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'custom_code': str(cus_num),
            'time': '{:%Y-%m-%d}'.format(date.today()),
            'pack_name': str(in_pack),
        }
        document0.merge_pages([cust_1])
        document0.write("./{}/ELB{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需增加版本信息版本

    if a[1] == 1:  #ELCK
        document1 = MailMerge(template1_ELCK)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'time': '{:%Y-%m-%d}'.format(date.today()),
            'pack_name': str(in_pack),
        }
        document1.merge_pages([cust_1])
        document1.write("./{}/ELB{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需修改

    if a[2] == 1:  #ELF
        document2 = MailMerge(template2_ELF)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'R_name': ref_name,
            'time': '{:%Y-%m-%d}'.format(date.today()),
        }
        document2.merge_pages([cust_1])
        document2.write("./{}/ELF{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需修改

    if a[3] == 1:  #ELM
        document3 = MailMerge(template3_ELM)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'F_name': film_name,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document3.merge_pages([cust_1])
        document3.write("./{}/ELM{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需修改

    if a[4] == 1:  #ELN
        document4 = MailMerge(template4_ELN)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document4.merge_pages([cust_1])
        document4.write("./{}/ELN{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需修改

    if a[5] == 1:  #ELP
        document5 = MailMerge(template5_ELP)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document5.merge_pages([cust_1])
        document5.write("./{}/ELP{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))

    if a[6] == 1:  #ELQC
        document6 = MailMerge(template6_ELQC)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document6.merge_pages([cust_1])
        document6.write("./{}/ELQC{}-{}.docx".format(new_folder_name, tjp_num,
                                                     Pro_name))  #需修改

    if a[7] == 1:  #ELW
        document7 = MailMerge(template7_ELW)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'custom_code': str(cus_num),
            'pcb_name': pcb_name,
            'pcb_sup': pcb_sup,
            'pin_head': pin_head,
            'pin_name': pin_name,
            'ref_name': ref_name,
            'ref_texture': ref_texture,
            'ref_ink': ref_ink,
            'ref_sup': ref_sup,
            'film_name': film_name,
            'film_sup': film_sup,
            'easy_tape': easy_tape,
            'easy_sup': easy_sup,
            'in_pack': in_pack,
            'out_pack': out_pack,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document7.merge_pages([cust_1])
        document7.write("./{}/ELW{}-{}.docx".format(new_folder_name, tjp_num,
                                                    Pro_name))  #需修改

    if a[8] == 1:  #ELHC
        document8 = MailMerge(template8_ELHC)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'custom_code': str(cus_num),
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document8.merge_pages([cust_1])
        document8.write("./{}/ELHC{}-{}.docx".format(new_folder_name, tjp_num,
                                                     Pro_name))  #需修改

    if a[9] == 1:  #ELSMT
        document9 = MailMerge(template9_ELSMT)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'pcb_sup': pcb_sup,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document9.merge_pages([cust_1])
        document9.write("./{}/ELSMT{}-{}SMT加工技术文件.docx".format(
            new_folder_name, tjp_num, Pro_name))  #需修改

    if a[10] == 1:  #ELT
        document10 = MailMerge(template10_ELT)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'custom_code': str(cus_num),
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document10.merge_pages([cust_1])
        document10.write("./{}/ELT{}-{}.docx".format(new_folder_name, tjp_num,
                                                     Pro_name))

    if a[11] == 1:  #ELY
        document11 = MailMerge(template11_ELY)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'P_name': pcb_name,
            'ref_name': ref_name,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document11.merge_pages([cust_1])
        document11.write("./{}/ELY{}-{}.docx".format(new_folder_name, tjp_num,
                                                     Pro_name))

    if a[12] == 1:  #ELFIL_H  缺少film_texture
        document12 = MailMerge(template12_FIL_H)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'supper': film_sup,
            # 'texture':,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document12.merge_pages([cust_1])
        document12.write("./{}/ELFIL{}面膜核准单({} {}).docx".format(
            new_folder_name, tjp_num, film_sup, Pro_name))

    if a[13] == 1:  #ELFIL_X
        document13 = MailMerge(template13_FIL_X)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'supper': film_sup,
            'time': '{:%Y-%m-%d}'.format(date.today())
        }
        document13.merge_pages([cust_1])
        document13.write("./{}/ELFIL{}面膜限度样品({} {}).docx".format(
            new_folder_name, tjp_num, film_sup, Pro_name))

    if a[14] == 1:  #ELREF
        document14 = MailMerge(template14_ELREF)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'ref_name': ref_name,
            'ref_texture': ref_texture,
            'ref_sup': ref_sup,
            'ref_ink': ref_ink,
            'time': '{:%Y-%m-%d}'.format(date.today()),
        }
        document14.merge_pages([cust_1])
        document14.write("./{}/ELREF{}塑壳材料核准单({}-{}).docx".format(
            new_folder_name, tjp_num, ref_sup, ref_name))

    if a[15] == 1:  #ELPCB
        document15 = MailMerge(template15_ELPCB)
        cust_1 = {
            'name': Pro_name,
            'bianhao': str(tjp_num),
            'time': '{:%Y-%m-%d}'.format(date.today()),
            'P_name': pcb_name,
            'pcb_sup': pcb_sup
        }
        document15.merge_pages([cust_1])
        document15.write("./{}/ELPCB{}线路板材料核准单({}-{}).docx".format(
            new_folder_name, tjp_num, pcb_sup, pcb_name))

    # if a[16] ==1: #ELPF
    #      document1 =MailMerge(template0_ELB)
    #      cust_1 = {'name': '1', #需修改读入
    #                'time': '{:%B %d,%Y}'.format(date.today()),
    #                'pack_name': '{:%Y-%m-%d}'.format(date.today()),
    #                'bianhao': '12342',
    #                'custom_code': '123'
    #                }
    #      document1.merge_pages([cust_1])
    #      document1.write("./{}.docx".format(12)) #需修改
    message()
Exemple #28
0
class handle_merge():
    def __init__(self):
        self.df_data = pd.DataFrame()
        self.template = 'C:/temp/mm/Test.docx'
        self.datafile = 'C:/temp/mm/Test.xlsx'
        self.path = 'C:/temp/mm/'
        self.document_1 = MailMerge(self.template)

    def read_files(self, ):
        # df_data = pd.DataFrame()
        try:
            self.df_data = pd.DataFrame(
                pd.read_excel(
                    io=self.datafile,
                    sheet_name='Sheet1',
                    # dtype={'ZF Global ID': 'str'},
                    header=0,
                    # skiprows=2))
                ))
            print(self.df_data.head())
        except Exception as e:
            print('Handle Employee Data Exception:', self.datafile, e)

    # def generate_pdf(self,docfile, pdf_file):
    #     # wdFormatPDF = 17
    #     word = DispatchEx("Word.Application")
    #     try:
    #         doc = word.Documents.Open(docfile, ReadOnly=1)
    #         # doc.SaveAs(pdf_file, FileFormat=wdFormatPDF)
    #         doc.ExportAsFixedFormat(OutputFileName=pdf_file,
    #                                 ExportFormat=17,  # 17 = PDF output, 18=XPS output
    #                                 OpenAfterExport=False,
    #                                 OptimizeFor=0,  # 0=Print (higher res), 1=Screen (lower res)
    #                                 CreateBookmarks=1,
    #                                 # 0=No bookmarks, 1=Heading bookmarks only, 2=bookmarks match word bookmarks
    #                                 DocStructureTags=True
    #                                 );
    #         doc.Close()
    #     except Exception as e:
    #         print('convert pdf failed,', docfile)

    def main(self):
        print(self.document_1.get_merge_fields())
        self.read_files()

        for n_idx, n_row in self.df_data.iterrows():
            dict = {
                "姓名": str(n_row['姓名']),
                "年龄": str(n_row['年龄']),
                "生日": str(n_row['生日']),
                "folder": 'folder1'
            }
            self.document_1.merge(**dict)

            file_path = self.path + 'xlsx/'
            if not os.path.exists(file_path):
                os.makedirs(file_path)

            file_docx = self.path + 'xlsx/' + n_row['姓名'] + '.docx'
            self.document_1.write(file_docx)
            # time.sleep(1)

            file_path = self.path + n_row['性别'] + '/'
            if not os.path.exists(file_path):
                os.makedirs(file_path)

            file_pdf = file_path + n_row['姓名'] + '.pdf'
            # file_pdf = self.path + 'pdfs/' + n_row['姓名'] + '.pdf'
            # self.generate_pdf(file_docx,file_pdf)
            convert(file_docx, file_pdf, keep_active=True)
        self.document_1.close()
def template():

    for i in range(8, max_row + 1):
        c_temp = sheet.cell(i, 1)
        ##Filter to pick out templates
        if c_temp.value == "CNR":

            document = MailMerge(template_1)
            ## Ideally, i can set up the transfer between Word and Excel
            #This can be solved by creating an index from variable names and itterate. Also, possibly and iloc solution instead of sheet cell plugs
            name = sheet.cell(2, 2)
            matter = sheet.cell(3, 2)
            dob = sheet.cell(4, 2)
            # Might find a "matching value" search to automate assignment from excel cell variables to merge fields
            ## After preseting mail merge fields, this operation needs to be automated, hopefully by itteration.
            document.merge(Name=name.value)
            document.merge(Matter=str(matter.value))
            # need to add date formating
            document.merge(DOB=str(dob.value))
            for j in range(1, max_column + 1):

                cel_obj = sheet.cell(row=i, column=j)

                if j == 2:
                    document.merge(Addressee=cel_obj.value)
                    addressee = cel_obj.value

                if j == 3:
                    # need to add date formating
                    document.merge(From=str(cel_obj.value))

                if j == 4:
                    # need to add date formating
                    document.merge(to=str(cel_obj.value))
            document.write(r"C:\Users\anton\OneDrive\Desktop\CNRtemp" +
                           addressee + ".docx")

        elif c_temp.value == "AB":

            document = MailMerge(template_2)
            name = sheet.cell(2, 2)
            matter = sheet.cell(3, 2)
            dob = sheet.cell(4, 2)
            document.merge(Name=name.value)
            document.merge(Matter=str(matter.value))
            # need to add date formating
            document.merge(DOB=str(dob.value))
            for j in range(1, max_column + 1):

                cel_obj = sheet.cell(row=i, column=j)

                if j == 2:
                    document.merge(Addressee=cel_obj.value)
                    addressee = cel_obj.value

                if j == 3:
                    # need to add date formating
                    document.merge(From=str(cel_obj.value))

                if j == 4:
                    # need to add date formating
                    document.merge(to=str(cel_obj.value))
            document.write(r"C:\Users\anton\OneDrive\Desktop\AB" + addressee +
                           ".docx")

        else:
            continue
Exemple #30
0
 def __init__(self):
     self.df_data = pd.DataFrame()
     self.template = 'C:/temp/mm/Test.docx'
     self.datafile = 'C:/temp/mm/Test.xlsx'
     self.path = 'C:/temp/mm/'
     self.document_1 = MailMerge(self.template)
Exemple #31
0
server = '{}'.format(var[1])
port = '{}'.format(var[2])
db ='{}'.format(var[3])
user = '******'.format(var[4])
pw = '{}'.format(var[5])
conn_str = ';'.join([driver, server, port, db, user, pw])
connetion = pyodbc.connect(conn_str)
coursor = connetion.cousor()
result = coursor.execute("SELECT pfio, akt_number, dbeg_akt, dend_akt, pricepol FROM OPERS_AKTS WHERE dog_date LIKE %2019% ORDER by akt_number").fetchall()
user = coursor.execute("SELECT pfio, name_work, dog_n, date_beg,date_end FROM OPERS WHERE date_beg LIKE %2019% ORDER by pfio").fetchall()

# Заполняем акты
df = df -2
for i in range (df):
    template = r"Акт сдачи-приеки.docx"
    document = MailMerge(template)
    signal = 0
    if "ИП " in oper[i]:
        signal = 1
        oper[i] = per[i][3:]
    pfio, name_work, dog_n, date_beg,date_end = search(oper[i])
    n_act, startD, endD, cost = searchact(oper[i])
    if signal == 1:
        name_work = "ИП " +name_work
        signal = 0
    date_act = dt
    operator = name_work
    print(operator)
    period = startD.strftime("%d.%m.%Y") +' - '+ endD.strftime("%d.%m.%Y")
    pwd = passwd[i]
    n_vs = n_ep = ""
 def test(self):
     MailMerge("tests/test_issue2.docx")
Exemple #33
0
def validate_submit(request):
    data = {}
    try:
        x = {}

        x["z"] = json.loads(request.GET.get("all_data", None))
        for c in x["z"]:
            c["address"] = Home.objects.get(home_phone=c["address"]).address
        if date.today().month >= 10:
            x["year"] = twelve(int(date.today().year) + 1 - 1911)
        else:
            x["year"] = twelve(date.today().year - 1911)

        x["title"] = request.GET.get("title", None)
        # print(os.path.join(BASE_DIR, "files" ,"files","mode1.docx"))
        if request.GET.get("title", None) == "祈求值年太歲星君解除沖剋文疏":

            tpl = DocxTemplate(
                os.path.join(BASE_DIR, "files", "files", "mode1.docx"))
        else:
            tpl = DocxTemplate(
                os.path.join(BASE_DIR, "files", "files", "mode2.docx"))

        tpl.render(x)

        file_location = os.path.dirname(
            os.path.dirname(os.path.abspath(__file__)))
        find_folder = os.path.join(file_location, "output")
        find_yes_no = os.path.exists(find_folder)

        if not find_yes_no:
            os.makedirs(find_folder)

        find_x = ""
        find_y = ""
        while (True):
            random_string = str(uuid.uuid4())
            find_x = os.path.join(find_folder, random_string + ".docx")
            if not os.path.exists(find_x):
                find_y = os.path.join(find_folder, random_string + ".pdf")
                break
        tpl.save(find_x)

        pythoncom.CoInitialize()
        word = Dispatch('Word.Application')
        doc = word.Documents.Open(find_x)
        doc.SaveAs(find_y, FileFormat=17)
        doc.Close()
        word.Quit()
        os.system(find_y)

        #處理名字表
        name_list = json.loads(request.GET.get("name", None))

        use_word = MailMerge(
            os.path.join(BASE_DIR, "files", "files", "straight.docx"))
        use_word.merge_rows('name1', name_list)
        use_word.write(
            os.path.join(BASE_DIR, "files", "files", "ok_straight.docx"))
        use_word = MailMerge(
            os.path.join(BASE_DIR, "files", "files", "row.docx"))
        use_word.merge_rows('name1', name_list)
        use_word.write(os.path.join(BASE_DIR, "files", "files", "ok_row.docx"))

        data = {"result": "已經送出"}

    except Exception as e:
        data = {"result": str(e)}
        print("錯誤" + str(e))
    return JsonResponse(data)
 def setUp(self):
     self.document = MailMerge(path.join(path.dirname(__file__), 'test_merge_table_rows.docx'))
     self.expected_tree = etree.fromstring('<w:document xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:ns1="http://schemas.microsoft.com/office/word/2010/wordml" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" mc:Ignorable="w14 wp14"><w:body><w:p ns1:paraId="28ACC80D" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00231DA5" w:rsidRDefault="00DA4DE0"><w:pPr><w:pStyle w:val="Title" /></w:pPr><w:proofErr w:type="spellStart" /><w:r><w:t>Grades</w:t></w:r><w:proofErr w:type="spellEnd" /></w:p><w:p ns1:paraId="07836F52" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>Bouke Haarsma</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>received</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> the </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>grades</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="002C29C5"><w:t>for</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t /></w:r><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> in the </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>table</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> below.</w:t></w:r></w:p><w:p ns1:paraId="58525309" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" /><w:tbl><w:tblPr><w:tblStyle w:val="LightShading-Accent1" /><w:tblW w:type="auto" w:w="0" /><w:tblLook w:firstColumn="1" w:firstRow="1" w:lastColumn="0" w:lastRow="1" w:noHBand="0" w:noVBand="1" w:val="04E0" /></w:tblPr><w:tblGrid><w:gridCol w:w="1777" /><w:gridCol w:w="4894" /><w:gridCol w:w="1845" /></w:tblGrid><w:tr ns1:paraId="599252DD" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="69486D96" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:r><w:t>Class Code</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="1AA11439" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:pPr><w:r><w:t>Class Name</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="3091846F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:pPr><w:r><w:t>Grade</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>ECON101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Economics 101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>ECONADV</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Economics Advanced</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>B</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>OPRES</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Operations Research</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="0B5730FD" ns1:textId="77777777" w:rsidR="00C829DD" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="6A211A5A" ns1:textId="4E90EB38" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:r><w:t>THESIS</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="12FCE443" ns1:textId="289CA6C6" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:pPr><w:proofErr w:type="spellStart" /><w:r><w:t>Final</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r><w:t xml:space="preserve"> thesis</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="0ACD9198" ns1:textId="413A3A4D" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr></w:tbl><w:p ns1:paraId="26A87379" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" w:rsidRPr="00DA4DE0"><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00DA4DE0" w:rsidRPr="00DA4DE0" w:rsidSect="002C0659"><w:pgSz w:h="16840" w:w="11900" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1800" w:right="1800" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>')  # noqa
Exemple #35
0
from __future__ import print_function
from mailmerge import MailMerge
from datetime import date

template = "Ms_Word_Table_Populate_Demo.docx"

document = MailMerge(template)
print(document.get_merge_fields())

sales_history = [{
    'prod_desc': 'Red Shoes',
    'price': '$10.00',
    'quantity': '2500',
    'total_purch': '$25,000.00'
}, {
    'prod_desc': 'Green Shirt',
    'price': '$20.00',
    'quantity': '10000',
    'total_purch': '$200,000.00'
}, {
    'prod_desc': 'Purple belt',
    'price': '$5.00',
    'quantity': '5000',
    'total_purch': '$25,000.00'
}]

document.merge_rows('prod_desc', sales_history)
document.write('test-output-table.docx')
print('DONE')
 def test(self):
     document = MailMerge(path.join(path.dirname(__file__), 'test_issue8.docx'))
     self.assertEqual(document.get_merge_fields(), {'testfield'})
Exemple #37
0
def create_sender_table(file_name, sender, receiver, r_date):
    template_file = "./demo.docx"
    file_path = file_name
    target_name = file_path.split("/")[-1].split(".")[0]
    target_name = target_name + "_거래내역서.docx"
    target_path = file_path.split("/")[:-1]
    target_path = "/".join(target_path)
    target_path = target_path + "/" + target_name
    print("File_path:", file_path)
    print("Target_path:", target_path)

    excel_document = openpyxl.load_workbook(file_path)
    sheet_name = excel_document.get_sheet_names()[0]
    sheet = excel_document.get_sheet_by_name(sheet_name)

    print("Active Sheet:", sheet_name)

    # read excel file.
    sales_history = []
    total_price = 0
    last_idx = 0;
    flag = 1
    all_rows = sheet.rows
    for idx, row in enumerate(all_rows, start=-1):
        # loop handling 1
        if idx > 1000:
            flag = -1
            break

        last_idx = idx

        if idx < 1:
            continue

        sales_item = {}
        sales_item["no"] = str(idx)
        sales_item["date"] = str(row[0].value)
        sales_item["date"] = "/".join(sales_item["date"].split("-")[1:3])
        sales_item["date"] = sales_item["date"].split(" ")[0]
        # loop handling 2
        print(sales_item["date"], end=" ")
        if sales_item["date"] == "None" or sales_item["date"] == "":
            flag = 0
            break
        sales_item["work"] = row[3].value
        sales_item["content"] = ""
        # price column exception handling.
        if row[4].value is None:
            total_price += 0
            sales_item["price"] = "-"
        elif type(row[4].value) is str:
            total_price += 0
        else:
            sales_item["price"] = format(row[4].value, ",")
            print(sales_item["price"])
            total_price += row[4].value
        sales_item["tax"] = row[7].value
        sales_history.append(sales_item)

    print("Reading Data >>>")
    if flag == 1:
        print("\tSUCCESS: reading excel data")
    elif flag == 0:
        print("\tWARNING: for-loop's idx reaches until date is None.")
    else:
        print("\tERROR: for-loop's idx > 1000.")

    # write word file.
    total_price = format(total_price, ",")

    print("Sum >>>")
    print("\tTotal_Data:", last_idx, "건")
    print("\tTotal_Price:", total_price, "원")

    print("Write FIle >>>")
    flag = 1
    try:
        document = MailMerge(template_file)
        document.merge(
            number=sender[0],
            company=sender[1],
            name=sender[2],
            address=sender[3],
            call=sender[4],
            fax=sender[5],
            business=sender[6],
            category=sender[7]
        )
        document.merge(
            receiver=receiver,
            r_date=r_date,
            total_price=total_price
        )
        document.merge_rows('no', sales_history)
        document.write(target_path)
    except Exception as e:
        flag = 0
        print("\tError:", e)
    if flag == 1:
        print("\tSUCCESS:Writing file ->", target_path)
Exemple #38
0
outputPath = sys.argv[5]
spreadsheet = sys.argv[1]
template = sys.argv[2]
sheetname = sys.argv[3]
rangee = sys.argv[4]
print(sys.argv)

# Handling if all rows in spreadsheet or just a defined amount
if rangee != 'all':
    rangestart = rangee.split('-')[0]
    rangeend = rangee.split('-')[1]
    rangee = 'defined'
else:
    rangee = rangee

document = MailMerge(template)

# Initializes Excel source file and sheet name variables provided by user
wb = xlrd.open_workbook(spreadsheet)  # Name of your excel file
sheet = wb.sheet_by_name(sheetname)  # Name of the sheet within your workbook

# Defining loop range
if rangee == 'all':
    firstRow = 1
    lastRow = sheet.nrows
if rangee == 'defined':
    firstRow = int(rangestart)
    lastRow = int(rangeend) + 1

#create output path if doesnt exist
if not os.path.exists(outputPath):
Exemple #39
0
def all():
    sg.theme('DarkBlue12')
    #sg.theme('Green')
    #sg.theme_previewer()
    layout2 = [[
        sg.Text('Укажите расположение до Word-шаблона:', size=(35, 1)),
        sg.InputText(size=(80, 1)),
        sg.FileBrowse()
    ],
               [
                   sg.Text('Укажите расположение файла Excel:', size=(35, 1)),
                   sg.InputText(size=(80, 1)),
                   sg.FileBrowse()
               ],
               [
                   sg.Text('Укажите путь для сохранения Паспортов:',
                           size=(35, 1)),
                   sg.InputText(size=(80, 1)),
                   sg.FolderBrowse()
               ], [sg.Submit(), sg.Cancel()]]
    window2 = sg.Window('Меню', layout2)
    event, values = window2.read()
    window2.close()
    WORD_path, Excel_path, Save_path = values[0], values[1], values[2]

    wb = load_workbook(Excel_path)
    sheet = wb.worksheets[0]
    for cell in sheet["A"]:
        if cell.value is None:
            cl = cell.row
            #print(cl)
            break

    short_asu = []
    for val in range(4, cl):
        short_asu.append(sheet.cell(row=val, column=4).value)

    sg.theme('DarkBlue12')
    progressbar = [[
        sg.ProgressBar(len(short_asu),
                       orientation='h',
                       size=(51, 10),
                       key='progressbar')
    ]]
    outputwin = [[sg.Output(size=(78, 20))]]

    layout = [[sg.Frame('Progress', layout=progressbar)],
              [sg.Frame('Output', layout=outputwin)],
              [sg.Submit('Start'), sg.Cancel()]]

    window = sg.Window('Custom Progress Meter', layout)
    progress_bar = window['progressbar']
    while True:
        event, values = window.read(timeout=10)
        if event == 'Cancel' or event is None:
            break
            raise SystemExit(1)
        elif event == 'Start':
            print("****** START ******")
            try:
                files = os.listdir(Save_path)
                if not files:
                    os.mkdir(Save_path + '/' + 'Шаблоны_паспортов')
                info_dir = 0
                for f, n in enumerate(files):
                    if n == 'Шаблоны_паспортов':
                        info_dir = 1
                    else:
                        info_dir = 2
                if info_dir == 2:
                    os.mkdir(Save_path + '/' + 'Шаблоны_паспортов')
                for d, item in enumerate(short_asu, 4):
                    myASU = []
                    for val in range(1, 49):
                        myASU.append(sheet.cell(row=d, column=val).value)
                    document = MailMerge(WORD_path)
                    # print(document.get_merge_fields())
                    # print(myASU)
                    document.merge(
                        Полное_наим=str(myASU[1]),
                        Краткое_наим=str(myASU[2]),
                        Краткое_наим_2=str(myASU[3]),
                        Собственник_АСУ_ТП=str(myASU[4]),
                        Эксп_Орг=str(myASU[5]),
                        Назначение_п1_3=str(myASU[6]),
                        Владелец_АСУТП=str(myASU[7]),
                        п1_6=str(myASU[8]),
                        Класс_Опасности=str(myASU[9]),
                        Крит_Тех_Проц=str(myASU[10]),
                        Соц_знач=str(myASU[11]),
                        Эконом_знач=str(myASU[12]),
                        Эколог_знач=str(myASU[13]),
                        п1_10=str(myASU[14]),
                        Режим_работы_АСУ_ТП=str(myASU[15]),
                        Наим_Тех_проц=str(myASU[16]),
                        Описание_п3_1=str(myASU[17]),
                        Описание_п3_2=str(myASU[18]),
                        Описание_п3_3=str(myASU[19]),
                        п3_7=str(myASU[20]),
                        Идент_Аутент=str(myASU[21]),
                        Описание_табл_п5_1=str(myASU[22]),
                        Упр_Доступом=str(myASU[23]),
                        Огрн_прог_среды=str(myASU[24]),
                        Защита_маш_нос_инф=str(myASU[25]),
                        Ауд_ИБ=str(myASU[26]),
                        Антивир=str(myASU[27]),
                        Пред_Вторж=str(myASU[28]),
                        Целостность=str(myASU[29]),
                        Резерв_оборуд=str(myASU[30]),
                        Рез_Коп=str(myASU[31]),
                        ЗИП=str(myASU[32]),
                        Мон_Тех_Сост=str(myASU[33]),
                        п5_10=str(myASU[34]),
                        Меры_физ_защ1=str(myASU[35]),
                        Меры_физ_защ2=str(myASU[36]),
                        Меры_физ_защ3=str(myASU[37]),
                        Меры_физ_защ4=str(myASU[38]),
                        Меры_физ_защ5=str(myASU[39]),
                        ИБП=str(myASU[40]),
                        п5_11=str(myASU[41]),
                        п5_12=str(myASU[42]),
                        У_Конфиг=str(myASU[43]),
                        п5_14=str(myASU[44]),
                        Реаг_Инц_ИБ=str(myASU[45]),
                        п6_16=str(myASU[46]),
                        Инф_обуч_персн=str(myASU[47]),
                    )
                    document.write(Save_path + '/' + str(myASU[0]) + '_' +
                                   'Паспорт_' + myASU[3] + '.docx')
                    dubl = Document(WORD_path)
                    fulPath = Save_path + '/' + 'Шаблоны_паспортов/' + 'Шаблон_' + str(
                        myASU[0]) + '_' + myASU[3] + '.docx'
                    dubl.save(fulPath)
                    print(str(myASU[0]) + ") ", myASU[3], " - Done")
                    progress_bar.UpdateBar(d + 1)
                print("****** FINISH ******")
            except:
                print("***** SHIT,ERROR ******")
    window.close()
def merge(jsonData, generalData):

    name = generalData['file_name']
    organization = generalData['organization_name']
    project_type = generalData['project_type']
    reference = generalData['reference_number']
    our_reference = generalData['our_reference_number']
    date = generalData['date']
    datetimeobject = datetime.strptime(date, '%m/%d/%Y')
    date = datetimeobject.strftime('%B %d, %Y')
    exchange_rate = generalData['exchange_rate']
    notes = generalData['notes']

    note = []
    note.append('Please add 15% VAT')
    note.append('Price is valid for 45 days')
    note.append('All price is in Ethiopian Birr')
    note.append(
        'Delivery will be within 45 days after PO, advance and bank foreign currency approval'
    )
    note.append('Payment Term 50% advance and remaining amount after delivery')
    note.append('Installation is NOT part of this Quote')
    note.append(
        'If there is discrepancy in price calculation the unit price will prevail'
    )

    selectedNotes = []
    for x in generalData['vat']:
        selectedNotes.append(int(x))

    temp = [0, 1, 2, 3, 4, 5, 6]
    for selected in selectedNotes:
        temp[selected] = ''

    temp_note = ['', '', '', '', '', '', '']

    for y in [0, 1, 2, 3, 4, 5, 6]:
        if temp[y] == '':
            temp_note[y] = note[y]

    for elem in temp_note:
        if elem == '':
            temp_note.remove(elem)

    unit_market_price = []
    markup_percentage = []
    item_no = []
    part_no = []
    description = []
    quantity = []
    total = 0

    for i in range(len(jsonData)):
        ump = float(jsonData[i]['unit_market_price']) * float(exchange_rate)
        unit_market_price.append(ump)
        markup_percentage.append(jsonData[i]['markup_percentage'])
        item_no.append(jsonData[i]['item_no'])
        part_no.append(jsonData[i]['part_no'])
        description.append(jsonData[i]['description'])
        quantity.append(jsonData[i]['quantity'])

    for i in range(len(jsonData)):
        total = total + (calculateUitPrice(float(unit_market_price[i]),
                                           float(markup_percentage[i])) *
                         float(quantity[i]))

    total = str(total)

    template = 'master.docx'
    document = MailMerge(template)

    document.merge(
        organization=organization,
        project_type=project_type,
        reference=reference,
        our_ref_no=our_reference,
        date=date,
        notes=notes,
        total=total,
    )
    item_table = [{
        'item_no':
        str(data['item_no']),
        'part_no':
        str(data['part_no']),
        'description':
        str(data['description']),
        'quantity':
        str(data['quantity']),
        'unit_price':
        str(
            calculateUitPrice(
                (float(data['unit_market_price']) * float(exchange_rate)),
                float(data['markup_percentage']))),
        'total_price':
        str(
            calculateUitPrice(
                (float(data['unit_market_price']) * float(exchange_rate)),
                float(data['markup_percentage'])) * float(data['quantity']))
    } for data in jsonData]

    reminder_table = [{
        'reminder': temp_reminder
    } for temp_reminder in temp_note]

    document.merge_rows('item_no', item_table)
    document.merge_rows('reminder', reminder_table)
    document.write('documents/' + name + '.docx')

    now = datetime.now()

    record = Record(path=name + '.docx',
                    date=now,
                    organization=organization,
                    project_type=project_type)
    record.save()

    return
class MergeTableRowsMultipartTest(EtreeMixin, unittest.TestCase):
    def setUp(self):
        self.document = MailMerge(path.join(path.dirname(__file__), 'test_merge_table_multipart.docx'))
        self.expected_xml = '<w:document xmlns:ns1="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"><w:body><w:p w:rsidP="00DA4DE0" w:rsidR="00231DA5" w:rsidRDefault="00DA4DE0"><w:pPr><w:pStyle w:val="Ttulo" /></w:pPr><w:r><w:t>Grades</w:t></w:r></w:p><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>Bouke Haarsma</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:r w:rsidR="00DA4DE0"><w:t>received the grades</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> for </w:t></w:r><w:r><w:t /></w:r><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> in the table below.</w:t></w:r></w:p><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" /><w:tbl><w:tblPr><w:tblStyle w:val="Sombreadoclaro-nfasis1" /><w:tblW w:type="auto" w:w="0" /><w:tblLook w:val="04E0" /></w:tblPr><w:tblGrid><w:gridCol w:w="1777" /><w:gridCol w:w="4894" /><w:gridCol w:w="1845" /></w:tblGrid><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="100000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:r><w:t>Class Code</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:val="100000000000" /></w:pPr><w:r><w:t>Class Name</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:val="100000000000" /></w:pPr><w:r><w:t>Grade</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>ECON101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Economics 101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>ECONADV</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Economics Advanced</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>B</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:r><w:t>OPRES</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>Operations Research</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr w:rsidR="00C829DD" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:val="010000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:r><w:t>THESIS</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:val="010000000000" /></w:pPr><w:r><w:t>Final thesis</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="0037127B"><w:pPr><w:cnfStyle w:val="010000000000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr></w:tbl><w:p w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" w:rsidRPr="00DA4DE0"><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00DA4DE0" w:rsidRPr="00DA4DE0" w:rsidSect="003B4151"><w:headerReference ns1:id="rId7" w:type="default" /><w:pgSz w:h="16840" w:w="11900" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1800" w:right="1800" w:top="1672" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>'
        self.expected_tree = etree.fromstring(self.expected_xml) 

    def test_merge_rows_on_multipart_file(self):
        self.assertEqual(self.document.get_merge_fields(),
                         {'student_name', 'study_name', 'class_name', 'class_code', 'class_grade', 'thesis_grade'})

        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
        )

        self.document.merge_rows('class_code', [
            {'class_code': 'ECON101', 'class_name': 'Economics 101', 'class_grade': 'A'},
            {'class_code': 'ECONADV', 'class_name': 'Economics Advanced', 'class_grade': 'B'},
            {'class_code': 'OPRES', 'class_name': 'Operations Research', 'class_grade': 'A'},
        ])

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)

        for part in self.document.parts.values():
            # only check the document part 
            if (part.getroot().tag == '{http://schemas.openxmlformats.org/wordprocessingml/2006/main}document'):
                self.assert_equal_tree(self.expected_tree, part.getroot())

    def test_merge_unified_on_multipart_file(self):
        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
            class_code=[
                {'class_code': 'ECON101', 'class_name': 'Economics 101', 'class_grade': 'A'},
                {'class_code': 'ECONADV', 'class_name': 'Economics Advanced', 'class_grade': 'B'},
                {'class_code': 'OPRES', 'class_name': 'Operations Research', 'class_grade': 'A'},
            ]
        )

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)

        for part in self.document.parts.values():
            # only check the document part 
            if (part.getroot().tag == '{http://schemas.openxmlformats.org/wordprocessingml/2006/main}document'):
                self.assert_equal_tree(self.expected_tree, part.getroot())
Exemple #42
0
outlook = win32com.client.Dispatch("Outlook.Application").GetNamespace("MAPI")
inbox = outlook.GetDefaultFolder(6) # "6" refers to the index of a folder - in this case,
                                    # the inbox. 
messages = inbox.Items.Restrict("[ReceivedTime] >= '" + str(datetime.date.today()) + "'")

for message in reversed(messages):
    if loop_run:
        break
    subject = message.subject
    Ex_extract = False
    if re.search("Mail Subject", str(subject)) :      
        body = message.Body
        body_list = body.splitlines()
        
        for val in body_list:
            if Ex_extract:
                Ex_list.append(val)
            if re.search("Example :", val):
                Ex_extract = True
                
        loop_run = True
        
template = 'ABC_Template.docx'
document = MailMerge(template)
print(document.get_merge_fields())

document.merge(
    Example = ', '.join(Ex_list)
    )
document.write('ABC.docx')
document.close()
# @File     :excelToWord.py
# 导入xlrd模块 导入mailerge模块 读取excel 以及写入word
import xlrd
from xlutils.copy import copy
from mailmerge import MailMerge

#设置文件名和路径
fname = 'd:/excelToWord/dms数据字典.xlsx'
#打开文件
filename = xlrd.open_workbook(fname)
# 获取当前文档的表(得到的是sheet的个数,一个整数)
sheets = filename.nsheets
sheet = filename.sheets()[0]  #通过sheet索引获得sheet对象
# print sheet
#获取行数
nrows = sheet.nrows
# 获取列数
ncols = sheet.ncols
#获取第一行,第一列数据数据
cell_value = sheet.cell_value(1, 1)
print(cell_value)

#打开模版
template = 'd:/excelToWord/模版.docx'
document = MailMerge(template)
print("Fields included in {}: {}".format(template,
                                         document.get_merge_fields()))
document.merge(test=cell_value)
document.write('d:/完成word.docx')
print('数据写入成功!')
from __future__ import print_function
from mailmerge import MailMerge
from datetime import date

# Define the templates - assumes they are in the same directory as the code
template_1 = "Practical-Business-Python.docx"
template_2 = "Practical-Business-Python-History.docx"

# Show a simple example
document_1 = MailMerge(template_1)
print("Fields included in {}: {}".format(template_1,
                                         document_1.get_merge_fields()))

# Merge in the values
document_1.merge(
    status='Gold',
    city='Springfield',
    phone_number='800-555-5555',
    Business='Cool Shoes',
    zip='55555',
    purchases='$500,000',
    shipping_limit='$500',
    state='MO',
    address='1234 Main Street',
    date='{:%d-%b-%Y}'.format(date.today()),
    discount='5%',
    recipient='Mr. Jones')

# Save the document as example 1
document_1.write('example1.docx')
class MergeTableRowsTest(EtreeMixin, unittest.TestCase):
    def setUp(self):
        self.document = MailMerge(path.join(path.dirname(__file__), 'test_merge_table_rows.docx'))
        self.expected_tree = etree.fromstring('<w:document xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:ns1="http://schemas.microsoft.com/office/word/2010/wordml" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" mc:Ignorable="w14 wp14"><w:body><w:p ns1:paraId="28ACC80D" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00231DA5" w:rsidRDefault="00DA4DE0"><w:pPr><w:pStyle w:val="Title" /></w:pPr><w:proofErr w:type="spellStart" /><w:r><w:t>Grades</w:t></w:r><w:proofErr w:type="spellEnd" /></w:p><w:p ns1:paraId="07836F52" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>Bouke Haarsma</w:t></w:r><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>received</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> the </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>grades</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="002C29C5"><w:t>for</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="002C29C5"><w:t xml:space="preserve"> </w:t></w:r><w:r><w:t /></w:r><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> in the </w:t></w:r><w:proofErr w:type="spellStart" /><w:r w:rsidR="00DA4DE0"><w:t>table</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r w:rsidR="00DA4DE0"><w:t xml:space="preserve"> below.</w:t></w:r></w:p><w:p ns1:paraId="58525309" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" /><w:tbl><w:tblPr><w:tblStyle w:val="LightShading-Accent1" /><w:tblW w:type="auto" w:w="0" /><w:tblLook w:firstColumn="1" w:firstRow="1" w:lastColumn="0" w:lastRow="1" w:noHBand="0" w:noVBand="1" w:val="04E0" /></w:tblPr><w:tblGrid><w:gridCol w:w="1777" /><w:gridCol w:w="4894" /><w:gridCol w:w="1845" /></w:tblGrid><w:tr ns1:paraId="599252DD" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="69486D96" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:r><w:t>Class Code</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="1AA11439" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:pPr><w:r><w:t>Class Name</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="3091846F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="1" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="100000000000" /></w:pPr><w:r><w:t>Grade</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>ECON101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Economics 101</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>ECONADV</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Economics Advanced</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>B</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="1699D5B6" ns1:textId="77777777" w:rsidR="00DA4DE0" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="5D81DF7F" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:r><w:t>OPRES</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="5A67E49A" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>Operations Research</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="5EB9BD23" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="1" w:oddVBand="0" w:val="000000100000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr><w:tr ns1:paraId="0B5730FD" ns1:textId="77777777" w:rsidR="00C829DD" w:rsidTr="00C829DD"><w:trPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:trPr><w:tc><w:tcPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="1" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="0" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="001000000000" /><w:tcW w:type="dxa" w:w="1809" /></w:tcPr><w:p ns1:paraId="6A211A5A" ns1:textId="4E90EB38" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:r><w:t>THESIS</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="5529" /></w:tcPr><w:p ns1:paraId="12FCE443" ns1:textId="289CA6C6" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:pPr><w:proofErr w:type="spellStart" /><w:r><w:t>Final</w:t></w:r><w:proofErr w:type="spellEnd" /><w:r><w:t xml:space="preserve"> thesis</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:type="dxa" w:w="1178" /></w:tcPr><w:p ns1:paraId="0ACD9198" ns1:textId="413A3A4D" w:rsidP="00DA4DE0" w:rsidR="00C829DD" w:rsidRDefault="00C829DD"><w:pPr><w:cnfStyle w:evenHBand="0" w:evenVBand="0" w:firstColumn="0" w:firstRow="0" w:firstRowFirstColumn="0" w:firstRowLastColumn="0" w:lastColumn="0" w:lastRow="1" w:lastRowFirstColumn="0" w:lastRowLastColumn="0" w:oddHBand="0" w:oddVBand="0" w:val="010000000000" /></w:pPr><w:r><w:t>A</w:t></w:r></w:p></w:tc></w:tr></w:tbl><w:p ns1:paraId="26A87379" ns1:textId="77777777" w:rsidP="00DA4DE0" w:rsidR="00DA4DE0" w:rsidRDefault="00DA4DE0" w:rsidRPr="00DA4DE0"><w:bookmarkStart w:id="0" w:name="_GoBack" /><w:bookmarkEnd w:id="0" /></w:p><w:sectPr w:rsidR="00DA4DE0" w:rsidRPr="00DA4DE0" w:rsidSect="002C0659"><w:pgSz w:h="16840" w:w="11900" /><w:pgMar w:bottom="1440" w:footer="708" w:gutter="0" w:header="708" w:left="1800" w:right="1800" w:top="1440" /><w:cols w:space="708" /><w:docGrid w:linePitch="360" /></w:sectPr></w:body></w:document>')  # noqa

    def test_merge_rows(self):
        self.assertEqual(self.document.get_merge_fields(),
                         {'student_name', 'study_name', 'class_name', 'class_code', 'class_grade', 'thesis_grade'})

        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
        )

        self.document.merge_rows('class_code', [
            {'class_code': 'ECON101', 'class_name': 'Economics 101', 'class_grade': 'A'},
            {'class_code': 'ECONADV', 'class_name': 'Economics Advanced', 'class_grade': 'B'},
            {'class_code': 'OPRES', 'class_name': 'Operations Research', 'class_grade': 'A'},
        ])

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)

        self.assert_equal_tree(self.expected_tree,
                               list(self.document.parts.values())[0].getroot())

    def test_merge_rows_no_table(self):
        """
        Merging of rows should not fail if there is no table with the given
        column in the document
        """
        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
            class_code=[
                {'class_code': 'ECON101', 'class_name': 'Economics 101', 'class_grade': 'A'},
                {'class_code': 'ECONADV', 'class_name': 'Economics Advanced', 'class_grade': 'B'},
                {'class_code': 'OPRES', 'class_name': 'Operations Research', 'class_grade': 'A'},
            ],
            no_table=[
                {'no_table': 'Table not available'}
            ]
        )

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)

        self.assert_equal_tree(self.expected_tree,
                               list(self.document.parts.values())[0].getroot())

    def test_merge_rows_remove_table(self):
        """
        When flag is set and there is no data in a table, table needs to be removed
        """
        self.document.remove_empty_tables = True
        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
            class_code=[]
        )

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)
        self.assertIsNone(
            list(self.document.parts.values())[0].getroot().find('.//{%(w)s}tbl' % NAMESPACES)
        )

    def test_merge_unified(self):
        self.document.merge(
            student_name='Bouke Haarsma',
            study='Industrial Engineering and Management',
            thesis_grade='A',
            class_code=[
                {'class_code': 'ECON101', 'class_name': 'Economics 101', 'class_grade': 'A'},
                {'class_code': 'ECONADV', 'class_name': 'Economics Advanced', 'class_grade': 'B'},
                {'class_code': 'OPRES', 'class_name': 'Operations Research', 'class_grade': 'A'},
            ]
        )

        with tempfile.TemporaryFile() as outfile:
            self.document.write(outfile)

        self.assert_equal_tree(self.expected_tree,
                               list(self.document.parts.values())[0].getroot())
from mailmerge import MailMerge
import os
from datetime import datetime as dt

# MS Word 템플릿 파일 불러오기
cwd = os.getcwd()
template_filename = "fax_cover_template.docx"
template_filepath = os.path.join(cwd, "data", template_filename)

# 템플릿 파일로 메일머지(mail-merge) 객체 만들기
document = MailMerge(template_filepath)

# 수신자 정보 입력하고, 메일머지 객체에 전달하기
document.merge(
    name='박수민',
    fax='031-777-7777',
    phone='031-777-7700',
    date='%s년 %s월 %s일' % (dt.now().year, dt.now().month, dt.now().day),
    title='세금계산서 재발행 요청의 건',
    memo='2019년 8월분',
)

# 메일머지 객체를 MS Word 문서로 저장하기
output_filepath = os.path.join(cwd, "output", "fax_cover_output.docx")
document.write(output_filepath)