How to Modify Excel XLSX Files with Python and Openpyxl Library

This video is about How to modify Excel XLSX files with Python and openpyxl library, and save modified data to a separate XLSX file.

This Python Excel and Openpyxl Tutorial is a quite detailed explanation for absolute beginners.
And it includes the following topics:

  • how to open Excel files with Openpyxl library
  • how to get an active spreadsheet
  • how to get a value of cells
  • how to save data to an XLSX file with Python
  • how to keep Excel formulas in cells when saving to a new file.

*** Web Scraping course ***
is available via Patreon here:
https://www.patreon.com/red_eyed_coder_club

or its landing:
https://red-eyed-coder-club.github.io/courses/practical-python-web-scraping

👕 T-shirts for programmers: https://bit.ly/3ir3Gci

🔔 Subscribe: https://www.youtube.com/c/RedEyedCoderClub/featured

#python

How to Modify Excel XLSX Files with Python and Openpyxl Library