How to Merge Multiple PDF Files in Excel Using Python (fast & easy)

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Did you know you can use Python code to merge PDF files in Excel? In this video, I am going to show you how to merge multiple PDF files in Excel using Python. It is a real time saver and will allow you to quickly combine the files. For this particular tutorial, we will be using the Python libraries xlwings & PyPDF2 to combine the PDF Files in Microsoft Excel.

You can find the Excel PDF Merger App here:
_________________________
👩‍💻 [OPTIONAL] VBA snippet to select a folder:
_________________________
📝 𝗦𝗢𝗨𝗥𝗖𝗘 𝗖𝗢𝗗𝗘:
from pathlib import Path # Standard Python Library
import xlwings as xw # pip install xlwings
from PyPDF2 import PdfFileMerger, PdfFileReader # pip install PyPDF2

# ---Documentations:

def main():

merger = PdfFileMerger()
pdf_files = list(Path(source_dir).glob("*.pdf"))

for pdf_file in pdf_files:

output_path = str(Path(__file__).parent / output_name)

if __name__ == "__main__":
main()

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[miguelorta]

Congratulations, excellent application! Is it possible to join PDF sheets in a specific order? I used your application but when I joined the PDF sheets the one I wanted to be sheet number 2 was number 17.

[fahuil]

Thanks for the tutorial! What modifications need to be done to module/vba in mac system?

[ahmedelhaddad]

great work thx
and pls how to do the opposite

[mattpensa]

Hey, great video. Can you post all of the code for the Sub SampleCall()? It's cut off in the view and I'm having some issues with the code in that sub.

[alecouto]

Great video. It makes me wonder if It's possible to detect and extract fields in a standardized pdf file and add it to a database?

[myfav]

Sir, I made executable file. Then the foll code is to be placed in module1
Sub MySample()
RunFrozenPython "F:\Currentwork\PDFmerge\pdfmerger.exe", "arg1 arg2"
End Sub
Here my both files excel and pdfmerger.exe is in F drive in above said path.
What is arg1 and arg2 I dont know?
I am not getting my combined file

[krishnajagadeesh]

Dear Sir without installing python we can't use
We need to only excel vba using to compile all pdf in single file it is possible sir
Kindly your advise

[abdullahrehman]

Can you teach how to convert excel Report to pdf?

[myfav]

Sir whenever I click merge button first cmd screen pops up : how to resolve this issue

[DuyPham-pxyj]

Hi
Can I ask if this application can be run on a computer that does not have python installed?
Thank you so much.

[myfav]

Sir, in my excel the code stops at RunPython, i did everything as per video. Do i have to install xlwings addin

[nullhas]

Hi,
Can we do this using only VBA? Without using python?

[analyticsadda]

I love this but I want to do this with VBA not using python.

[sathikraja]

I am get below mentioned Error:


Error

Traceback (most recent call last):

File "<string>", line 1, in <module>

File "c:\users\sathikraja.segu\pdfmerger\pdfmerger.py", line 3, in <module>

from PyPDF2 import PdfFileMerger, PdfFileReader

ModuleNotFoundError: No module named 'PyPDF2'



Press Ctrl+C to copy this message to the clipboard.

OK

Kindly help me

[madhurimotamarri]

Im getting an error at the very beginning:

Error

Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings > Manage App Execution Aliases.



Press Ctrl+C to copy this message to the clipboard.

OK