| 123456789101112131415161718192021222324252627282930313233343536373839 |
- from fast_excel_to_bill.bill_doc.docx_builder import DOCFileBuilder
- from fast_excel_to_bill import config_for_custom_bills
- from tool_lib import datetime_functions
- current_month_year= datetime_functions.get_current_month_year_as_str()
- docx_output_path = config_for_custom_bills.docx_output_dir_path+ r'\bill_{}.docx'.format(current_month_year)
- def main():
- # Get Data which is necessary for the docx
- data_from_excel = ...
- burden_date = ...
- data_from_excel.append(burden_date)
- # Create a doc file which is based on a docx template
- builder_obj = DOCFileBuilder(config_for_custom_bills.docx_input_path, docx_output_path)
- place_holders = config_for_custom_bills.list_of_place_holders
- for place_holder in place_holders:
- builder_obj.replace_custom_placeholder_in_doc(place_holder, data_from_excel)
- builder_obj.replace_dates_string_in_standard_text('03.11.2022')
- builder_obj.replace_dates_string_in_all_tables('03.11.2022')
- keys = ['KW', 'Leistung', 'Zeit in Stunden', 'Betrag in Euro']
- example_tuple = [(123123, 213123, 12312312, 445235)]
- key_table = builder_obj.search_table_with_key_columns(keys)
- builder_obj.replace_rows(key_table, example_tuple)
- builder_obj.delete_empty_rows_in_table(key_table, 4)
- builder_obj.document.add_page_break()
- key_table = builder_obj.search_table_with_key_columns(['KW', 'Leistungsübersicht'])
- builder_obj.delete_empty_rows_in_table(key_table, 2)
- data_to_bill_doc = ...
- # Transform the doc file to a pdf file
- doc_to_pdf = ...
- if __name__ == '__main__':
- main()
|
