👉 Explore All My Excel Solutions: [ Ссылка ]
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This tutorial explains how to transfer data from multiple excel workbooks into one Master File using Python. Even those who are not well versed with Python can easily get this done by simply following the video on how to use this code.
📝 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:
Download the Project Folder here:
► [ Ссылка ]
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
Remark: In the video, I have used the os dependent '.api' method to copy sheets.
Since xlwings version 0.22 the '.copy()' has been implemented. Therefore I have changed the code below slightly.
Additionally, xlwings.App() can now be used as context manager in xlwings v0.24.3:
This will make sure that there are no zombie processes left over on Windows, even if you use a hidden instance and your code fails.
It is therefore recommended to use it whenever you can. I have adjusted the code as follows:
👩💻 𝗣𝘆𝘁𝗵𝗼𝗻 𝗖𝗼𝗱𝗲
from pathlib import Path # Standard Python Module
import time # Standard Python Module
import xlwings as xw # pip install xlwings
# Adjust Paths
BASE_DIR = Path(__file__).parent
SOURCE_DIR = BASE_DIR / 'Files'
OUTPUT_DIR = BASE_DIR / 'Output'
# Create output directory
OUTPUT_DIR.mkdir(parents=True, exist_ok=True)
excel_files = Path(SOURCE_DIR).glob('*.xlsx')
# Create timestamp
t = time.localtime()
timestamp = time.strftime('%Y-%m-%d_%H%M', t)
with xw.App(visible=False) as app:
combined_wb = app.books.add()
for excel_file in excel_files:
wb = app.books.open(excel_file)
for sheet in wb.sheets:
sheet.copy(after=combined_wb.sheets[0])
wb.close()
combined_wb.sheets[0].delete()
combined_wb.save(OUTPUT_DIR / f'all_worksheets_{timestamp}.xlsx')
combined_wb.close()
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): [ Ссылка ]
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): [ Ссылка ]
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): [ Ссылка ]
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): [ Ссылка ]
📑 Excel Templates: [ Ссылка ]
🎓 My Courses: [ Ссылка ]
📚 Books, Tools, and More: [ Ссылка ]
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: [ Ссылка ]
📸 Instagram: [ Ссылка ]
💻 GitHub: [ Ссылка ]
💬 Discord: [ Ссылка ]
📬 Contact: [ Ссылка ]
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: [ Ссылка ]
