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
7.85 GEEK