12 Python PDF Automation Mail Merge-Generate Bulk PDF Document from Excel, Bulk PDF Invoice Creation

Python2020

Подписаться 3,1 тыс.

Просмотров 5 тыс.

50% 1

#MailMerge #docxtpl #PythonMailMerge #bulkpdfdocument
#bulkpdfcreationusingpython
#automatepdfcreation
#pythonmailmerge
#pythoncreatepdf
00:00 Intro of Create Bulk PDF from Excel Data
04:00 Python Docxpl Generate Bulk PDF receipts
08:00 Set Word Template to Generate Bulk PDFs using python Docxpl
15:00 Python Create Multiple word documents from Excel Data
20:00 Python How to Generate Bulk PDF documents from excel data using same template
25:00 Python Docxpl to create multiple pdf documents
In this video we will learn how to create BULK PDF POLICY CREATION or BULK PDF CREATION or Creating PDF Document in BULK using data from excel and each document would be separate for each row in excel
Reading Data from excel and do the mapping in word file, loop through each record and create individual pdf document for each customer with no cost
Learn Python - Python Tutorials - Python for Beginners
**********************************************************************************
Python Tutorial Playlist - Setup -
/ python2020

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@rahulteja536 2 года назад

Thank you brother, hard to find this kind of knowledge sharing videos.

@artigarg1309 3 года назад

Tried this while watching your video... Worked well... Thanks to python and thank you for your effort for explaining

@clyzhang2000 2 года назад

Thank you very much

@Raj-ph1py 2 года назад

Really valuable tutorial. Thank you

@Python2020 2 года назад

Thank you Raj Bhai

@flutterflowhack Год назад

Very helpful video !!!!! Thank you

@Python2020 Год назад

Your welcome 😊😊

@rajniarora7605 3 года назад

Supper Solution

@sandeepal1 2 года назад

@Python2020: This is really fantastic tutorial. Really leant a lot. However I have one question in my mind i.e. how to handle if customer name is same and rest all details are different and want to create single invoice for each customer, means multiple records will be there for single customer

@Python2020 2 года назад

Thanks a lot sandip for your appreciation, we can keep same name in the template itself if it's only one customer.. Second we can give names in excel rows , multiple rows same name

@vinayvasi Год назад

Thanks for this useful video. can you make a video with same example for multiple rows of one customer?

@Python2020 Год назад

You mean extract table from PDF..??

@vinayvasi Год назад

@@Python2020 no, I am talking about mail merge table, df having multiple row items for one customer. Invoice type thing

@Python2020 Год назад

Please check video no 12 on my channel... That is for pdf creation... For reading pdf table and store that in dataframe you will hv on this weekend

@cpkanojiya 2 года назад

Sir namaste, this is very usefull video. Sir I have one query that we are use many template. Than how can modify this code. Please suggest me.

@Python2020 2 года назад

You can watch video 95 on my channel, install pycharm and write the code

@ahmedhelal920 2 года назад

thanks for sharing , but i have question , what if customer have more than one row , how can we deal with that ?

@Python2020 2 года назад

@Ahmed Helal - My understanding is that in excel you have multiple rows for same customer which have few related data points in first row and few in another row... For that store unique values in a list from excel column customer name and then loop on the list item , in loop filter entire column by customer then map values to word format... watch video 8-1 to get understanding on pandas filters

@RAHULKUMAR-yk3pu Год назад

in this same code we should bulk email through Outlook

@akshaysingh7868 3 года назад

Long Searching Solution of PYTHON PDF GENERATOR

@theplausibleengima2208 2 года назад

Had any idea how to automate ppt using python with excel

@Python2020 2 года назад

Hi, what you want to do in PPT let me know the exact requirement to comment further

@theplausibleengima2208 2 года назад

@@Python2020 I have a requirement to read the data from excel using data frame and the data should be sent to ppt that should be aligned in a magazine layout

@Python2020 2 года назад

Ok.. I will try from mi side meanwhile try following. 1- covert dataframe to html table 2- add style like header, border by converting html in text and then you can save that as webpage and see if required formatting is available If these steps are done job will become easy.

@theplausibleengima2208 2 года назад

@@Python2020 actually I have some news data it has to be sent to only 1 slide point of view with comparison layout in ppt

@AkshayPoklekar Год назад

I'm getting error TypeError: keywords must be string For line tpl.render(context [r_index])

@Python2020 Год назад

Are you able to copy the text manually from pdf to Notepad...??

@AkshayPoklekar Год назад

@@Python2020 pdf not getting generated. I'm getting this error when I run the program

@Python2020 Год назад

Can you share the line of code where this error is coming

@AkshayPoklekar Год назад

@@Python2020 tpl.render(context[r_index])

@Python2020 Год назад

It works fine... You can try this as well if you want.. I have one more ..Macro to generate pdf from excel... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FAxN6-sZdBg.html